怎样得出table1中有3个人的数据呢(tom重复两条)

[germ007]

table 1

id name num
1 tom 44
2 jack 22
3 tom 23
4 rose 11

怎样得出table1中有3个人的数据呢(tom重复两条)
这个不行 select coun(id) as num from table1 group by name

[germ007]

ding..............

[不耐烦]

select distinct (name) as num from table1

[germ007]

不对吧,显示的是tom的名字

[germ007]

应该是这样,解决了,哈,谢谢
select count(distinct name) as num from table1

[lzp4881]

select * from table1 where id in (select min(id) from table1 group by name having count(*)=3)