按频度高低的select语句怎么写? --体现水果出现频度;with acherat as( select FruitName,count(1) as sumcnt from tb group by FruitName)select top 5 *from acheratorder by sumcnt -- asc/desc 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select top 5 FruitName from TableFruit group by FruitName order by count(FruitID) 排序错了,改一下:select top 5 FruitName from TableFruit group by FruitName order by count(FruitID) desc SELECT TOP 5 FruitName FROM TBGROUP BY FruitNameORDER BY COUNT(FruitID) DESC 请教一个Sql语句 先查询出位数为13位的字段 然后在倒数第二位加0 简单问题 100分求教alter问题,急!! 求sql语句 如何按照数字的升序对表格进行排序 一个比较难搞的SQL问题 求助:sql 2008 安装出错! 视图问题 asp连接2003上的sqlserver的怪事 sql server 2008 r2执行远程存储过程返回记录集出错 sql 批量修改XML 值 。
select top 5 FruitName from TableFruit group by FruitName order by count(FruitID) desc
GROUP BY FruitName
ORDER BY COUNT(FruitID) DESC