查询同一作者在不同出版社出版的图书
SELECT 'author', 'book_name', 'publisher' FROM 'master'.'dbo'.'book01' WHERE 'author' IN ( SELECT 'author' FROM 'master'.'dbo'.'book01' GROUP BY 'author' HAVING COUNT(DISTINCT 'publisher') > 1 ) ORDER BY 'author', 'book_name', 'publisher'
原文地址: https://www.cveoy.top/t/topic/nqzf 著作权归作者所有。请勿转载和采集!