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)
转载于:https://www.cnblogs.com/wlc297984368/p/6072850.html