查询同一出版社出版的同名图书 - SQL 查询示例

SELECT [bookid] ,[book_type] ,[publisher] ,[author] ,[book_name] ,[price] FROM [master].[dbo].[book01] WHERE publisher = '出版社名称' AND book_name IN ( SELECT book_name FROM [master].[dbo].[book01] WHERE publisher = '出版社名称' GROUP BY book_name HAVING COUNT(*) > 1 )