菜鸟请教：求一SQL语句

[galaxy_1981]

表A，结构如下：

ID Sid Fee
1 A 100
2 A 200
3 B 300
4 C 150
5 B 50
…………


想要把Sid,重复的找出来（不重复的不用显示），请问SQL语句怎么写？？

显示如下结果：

Sid 重复几次

A 2
B 2
…………

[--小F--]

select sid,count(1) as 重复之次 from tb group by sid having count(1)>1

[發糞塗牆]

select Sid,count(1) from tab group by sid having count(1)>=2

[galaxy_1981]

引用 1 楼 fredrickhu 的回复:

select sid,count(1) as 重复之次 from tb group by sid having count(1)>1

我来试试看