sql server 判断相同值的数据

from [books]

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

sql server 判断相同值的数据

标签：