用group by ... having...
比如查询，a,b,c,d四列组合是否有重复的
select a,b,c,d,count(*)from tablenamegroup by a,b,c,dhaving count(*) > 1
