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