举个栗子, 求出相同作者的书
select * from [books]
where author in (select author from [books] group by author having count(author) > 1)
sql server 判断相同值的数据
原文：http://www.cnblogs.com/facial/p/5142872.html
