Group by 代替 order by神奇之笔!
来源:互联网 发布:成本核算什么软件好 编辑:程序博客网 时间:2024/05/03 04:07
groupby 有一个原则,就是select 后面的所有列中,没有使用聚合函数的列,必须出现在group by 后面 .
按照TDR.SORT排序,把TDR.SORT放到GROUP BY 后,不需要ORDER BY。select里面可以没有TDR.SORT。
SELECT TT.NAME,SUM(TD.PAGE_COUNT),TDR.TEMPLATE_DIR_NAME FROM T_DOCUMENT_INFO TD,T_TEMPLATE_DOC TT, T_TEMPLATE_DIR TDR WHERE CASE_NO ='027912050080003' AND TD.TEMPLATE_DOC_ID = TT.TEMPLATE_DIR_ID AND TD.DOC_TYPE=TT.DOC_TYPE AND TDR.TEMPLATE_DIR_ID=TD.TEMPLATE_DOC_ID GROUP BY TDR.SORT,TT.NAME,TDR.TEMPLATE_DIR_NAME
- Group by 代替 order by神奇之笔!
- Group by order by神奇之笔!!!!
- group by order by
- group by + order by
- group by ,order by 认识
- group by 、 having 、 order by
- Oracle Group By Order By
- group by与order by
- group by 与 order by
- order by和group by
- group by 、 having 、 order by
- group by havding order by
- sql group by order by
- having , group by , order by
- order by和group by
- group by和order by
- group by和order by
- order by group by 区别
- 数字证书的格式与使用习惯
- 如何创建CSS
- 正则表达式语法
- ADF实现单表维护2
- RadTreeView控件添加删除节点
- Group by 代替 order by神奇之笔!
- VLC不同版本对于H264标准文件的支持[VLC不能播H264]
- 虚继承与虚基类的本质
- JAVA对象大小与引用
- Java多线程设计模式详解学习笔记六——Balking
- try....catch...finally 妙用
- Jboss AS调优与瘦身
- IE8上传文件时获取文件本地路径问题(C:\fakepath\……)的解决办法
- 将记事本默认编码设为UTF-8的方法