SELECT TOP 1000 bookid book_type publisher author book_name price FROM masterdbobook01查询同一出版社出版的同名 图书

SELECT [bookid], [book_type], [publisher], [author], [book_name], [price] FROM [master].[dbo].[book01] WHERE [book_name] IN ( SELECT [book_name] FROM [master].[dbo].[book01] GROUP BY [book_name] HAVING COUNT() > 1 ) AND [publisher] IN ( SELECT [publisher] FROM [master].[dbo].[book01] GROUP BY [publisher] HAVING COUNT() > 1 ) ORDER BY [publisher], [book_name]