orderby与groupby同时使用方法
2014-11-03来源:易贤网
,p>1.

SELECT Sale.BaoBeiName, Count(*) AS 销售量

FROM Sale

GROUP BY Sale.BaoBeiName order by Count(*) desc;

2.

SELECT Sale.BaoBeiName, sum(*) AS 合计 FROM Sale

GROUP BY Sale.BaoBeiName order by sum(*) desc;

更多信息请查看IT技术专栏

2026上岸·考公考编培训报班

  • 报班类型
  • 姓名
  • 手机号
推荐信息