select A,B from table1 group by A,B having count(*) > 1; 转载于:https://www.cnblogs.com/Anthony518/p/11231631.html