orderby與groupby同時使用方法

字號:

,p>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;