select * from sys_user
where name in (select name from sys_user group by name having count(name) > 1);
mysql根据某个字段查询重复数据记录
最新推荐文章于 2024-07-30 03:50:30 发布
select * from sys_user
where name in (select name from sys_user group by name having count(name) > 1);