Mysql查询某字段值重复的数据
select user_name,count(*) as count from user group by user_name having count>1;
去重复
creat table temp as select max(id) as id,a1,a2 from a group by a1,a2
Mysql查询某字段值重复的数据
select user_name,count(*) as count from user group by user_name having count>1;
去重复
creat table temp as select max(id) as id,a1,a2 from a group by a1,a2