select * from table_name
where id in (select id from table_name group by id having count
(id) > 1) ;
查询数据库重复数据
最新推荐文章于 2024-06-21 08:37:29 发布
select * from table_name
where id in (select id from table_name group by id having count
(id) > 1) ;