sql查出重复数据及重复条数

select id,id2,count(1) duplicateNumber
from TableA

group by id,id2

having count(*)>2

 

其中id、id2为联合主键，联合主键可以更多如：

select id,id2,id3,id...... ,count(1) duplicateNumber
from TableA

group by id,id2,id3,id.......

having count(*)>2