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;
|
|
|
文章录入:杜斌 责任编辑:杜斌 |
|
上一篇文章: SQL语句基础学习之SQL语法总结 下一篇文章: SQL语句基础学习之Delete |
【字体:小 大】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口】 |
|
|