举个栗子, 求出相同作者的书select * from [books] where author in (select author from [books] group by author having count(author) > 1)