mysql 数据表中查找重复记录

//例一：
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; 

mysql 数据表中查找重复记录

标签：