表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)