打印本文 
关闭窗口 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;
打印本文 关闭窗口 | 打印本文 关闭窗口 |
|
| orderby与groupby同时使用方法 | |
| 作者：佚名 文章来源：不详 点击数 更新时间：2007/11/21 20:32:05 文章录入：杜斌 责任编辑：杜斌 | |
|
|
|
|
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; |
|
| 打印本文 关闭窗口 |