获取相同记录的条数？？？

[xq1981]

表A（aid,aname）有重复的记录，如何获得重复记录的条数？

[静_心]

SELECT aname,COUNT(aname) FROM testA
group by aname having count(Aname)>=1

[xq1981]

非常感谢1楼！但如果我的表是几个字段呢？比如：A（aid,aname,aaddress,ajob）,就是这几个字段全部相同的记录数？？？

[llsen]

select aid,aname,aaddress,ajob,count(*)
from A
group by aid,aname,aaddress,ajob
having count(*) > 1

[中年秃头大叔]

select aid,aname,aaddress,ajob,count(*)
from A
group by aid,aname,aaddress,ajob
having count(*) > 1
mark

[MadeInTexas]

select aid,aname,aaddress,ajob,count(*)
from A
group by aid,aname,aaddress,ajob
having count(*) > 1

[xq1981]

谢谢！散分啦