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

Question

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

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

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