判断表中是否有重复行

select A,B from table1 group by A,B having count(*) > 1;

原文地址:https://www.cnblogs.com/Anthony518/p/11231631.html