SELECT TOP 1000 bookid book_type publisher author book_name price FROM masterdbobook01查询同一作者在不同出版社出版的图书as

SELECT [author], [book_name], COUNT(DISTINCT [publisher]) as [num_publishers] FROM [master].[dbo].[book01] GROUP BY [author], [book_name] HAVING COUNT(DISTINCT [publisher]) > 1