首页 > 网站 > 建站经验 > 正文

orderby与groupby同时使用方法

2019-11-02 15:53:00
字体:
来源:转载
供稿:网友

  1.

  SELECT Sale.BaoBeiName, Cou

世界历史[www.9-39.com/html/world/]
nt(*) 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;

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表