select *,count(*) from T order by a,b,c group by a,b,c having count(*)>1 说明:T是你要查重的表,A,B,C是要查重的字段,COUNT(*)>1 记录数大于1说明有重复记录