您现在的位置: 万盛学电脑网 >> 程序编程 >> 数据库 >> mssql数据库 >> 正文

orderby与groupby同时使用方法

作者:佚名    责任编辑:admin    更新时间:2022-06-22

  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;