sql server 判断相同值的数据

举个栗子, 求出相同作者的书

select * from [books]

 where author in (select author from [books] group by author having count(author) > 1)