sql server 判断相同值的数据时间:2023-03-10 03:04:25 举个栗子, 求出相同作者的书 select * from [books] where author in (select author from [books] group by author having count(author) > 1)