orderby与groupby同时使用方法
www.nanhushi.com 佚名 不详
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;