1.无论主键唯一不唯一都可以,理解好这个,万能的。。。
select * from t_user where u_name in (select u_name from t_user group by u_name having count(*)>1)
该sql语句查出了所有重复的数据
2.该语句去除重复的数据
select * from t_user where id in (select min(id) from t_user group by u_name)
1.无论主键唯一不唯一都可以,理解好这个,万能的。。。
select * from t_user where u_name in (select u_name from t_user group by u_name having count(*)>1)
该sql语句查出了所有重复的数据
2.该语句去除重复的数据
select * from t_user where id in (select min(id) from t_user group by u_name)