//例一：
select name1,count(*) as count from table_name group by name1 having count>1;
//例二：
select name1,name2 ,count(name1) as countb,count(name2) as count from table_name group by name1,name2 having count>1 and countb >1;
原文：http://www.cnblogs.com/langtianya/p/5086651.html