| 标题 | orderby与groupby同时使用方法 |
| 分类 | 范文、应用文-IT技术专栏-数据库 |
| 范文 |
,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; |
| 随便看 |
|
客官网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板,是学习及工作的有利工具。