34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 5 FruitName FROM TB
GROUP BY FruitName
ORDER BY COUNT(FruitID) DESC
select top 5 FruitName from TableFruit group by FruitName order by count(FruitID) desc
--体现水果出现频度
;with acherat as
(
select FruitName,count(1) as sumcnt
from tb
group by FruitName
)
select top 5 *
from acherat
order by sumcnt -- asc/desc