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