SQL查询平均价格语句

Question

SQL数据库查询语句

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [BoID]
      ,[BoTitle]
      ,[BoAuthor]
      ,[BoPublisher]
      ,[BoPublicationDate]
      ,[BoPrice]
      ,[BoStatus]
  FROM [CollegeCard_DB].[dbo].[Books]

select DISTINCT BoPublisher,count(BoPublisher) 
over(partition by BoPublisher )
from Books

怎样查询出图书馆藏书最多的出版社

Answer 1

SELECT TOP 1 BoPublisher,COUNT(*) FROM Books
GROUP BY BoPublisher
ORDER BY COUNT(*) desc