请问一条sql查询

请教一条sql查询
表a,有id,name.
如何把name值相同的条数查到.


谢谢

[解决办法]
select count(*),name from a group by name 啊
[解决办法]

SQL code

select *from 表a twhere exists (select 1 from 表a where name=t.name and id!=t.id)