orderby與groupby同時(shí)使用方法

,p>1.
    SELECT Sale.BaoBeiName, Count(*) AS 銷售量
    FROM Sale
    GROUP BY Sale.BaoBeiName order by Count(*) desc;
    2.
    SELECT Sale.BaoBeiName, sum(*) AS 合計(jì) FROM Sale
    GROUP BY Sale.BaoBeiName order by sum(*) desc;