#orderby与groupby同时使用方法 搜索结果
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;
