Mysql查询重复数据
select * from 表名 where 字段名 in(select 查询字段名 表名 group by 字段名 having count(字段名) > 1);
示例:
1.查询用户列表中名称重复的数据
select * from t_users where `name` in (select name from t_users group by name having count(name) > 1);
2.统计相同数据出现的次数
根据名称、性别统计出现相同数据的次数及名称与性别
数据表数据
MySQL查询语句
select count(*) as ct, name, sex from t_users group by name,sex having ct > 1;
结果:
3.使用 group by 来查看不重复的数据
select name,sex from t_users group by name,sex;
4.使用distinct来过滤重复数据
select distinct(name),id,sex from t_users ORDER BY id DESC;