查询数据库重复数据

分类: IT文章 • 2025-01-09 09:53:44

select * from new_doc_collection where title in (select title from new_doc_collection group by title having count(title) > 1)
and id in (select min(id) from new_doc_collection group by title having count(title)>1)