查询数据库重复数据

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)