在我看来是复杂的SQL
来源:互联网 发布:传智播客c语言百度云 编辑:程序博客网 时间:2024/05/20 00:50
SELECT GP_OFFICE_ID, E, F, SUM(A) AS A,SUM(AA) AS AA ,SUM(B) AS B, SUM(BB) AS BB, SUM(C) AS C, SUM(CC) AS CC, SUM(D) AS D, SUM(DD) AS DD FROM (SELECT GP_OFFICE_ID, E, F, SUM(CASE GP_TYPE WHEN 1 THEN isnull(a.GP_INFO_POINT, 0) ELSE 0 END) AS A, SUM(CASE GP_TYPE WHEN 1 THEN 1 ELSE 0 END) AS AA, SUM(CASE GP_TYPE WHEN 2 THEN isnull(a.GP_INFO_POINT, 0) ELSE 0 END) AS B, SUM(CASE GP_TYPE WHEN 2 THEN 1 ELSE 0 END) AS BB, SUM(CASE GP_TYPE WHEN 3 THEN isnull(a.GP_INFO_POINT, 0) ELSE 0 END) AS C, SUM(CASE GP_TYPE WHEN 3 THEN 1 ELSE 0 END) AS CC, SUM(CASE GP_TYPE WHEN 4 THEN isnull(a.GP_INFO_POINT, 0) ELSE 0 END) AS D, SUM(CASE GP_TYPE WHEN 4 THEN 1 ELSE 0 END) AS DD FROM (SELECT GP_OFFICE_ID, DATEPART(YEAR, CREATE_DATE) AS E, DATEPART(MONTH, CREATE_DATE) AS F, GP_TYPE, GP_INFO_POINT FROM GL_PUB_INFO) a GROUP BY GP_OFFICE_ID, E, F, GP_TYPE) b GROUP BY GP_OFFICE_ID, E, F ORDER BY E DESC,F DESC
- 在我看来是复杂的SQL
- 蚂蚁金服CTO程立:技术的价值与意义_在我看来是这样的
- 事实是复杂的
- 有些复杂的SQL
- 一个复杂的sql
- 复杂的sql语句
- 一个“复杂的”SQL
- SQL复杂的查询
- 复杂的sql语句
- 比较复杂的sql
- 库是相当复杂的
- 简单是终极的复杂。
- 不是我冷血,他们心中的噩梦在我看来不值一提
- 博客在我看来
- 命名复杂的SQL对象
- 一个比较复杂的sql
- 一个复杂的SQL函数
- 复杂的sql 行转列揭秘
- osworkflow api 之 spi
- 如何得到其它进程的启动命令行参数 (转)
- CVS中增加目录及标签和分支
- MYSQL数据迁移tips,ORA-00907: missing right parenthesis
- 在VFP中使用Memo字段保存和释放文件
- 在我看来是复杂的SQL
- C#打印DataGrid中的数据
- What's the difference between an event and a delegate?
- When should I use == and when should I use Equals?
- 一些常用的Eclipse 3.0的插件
- 改进JAVA字符串分解的方法
- Speed of direct calls vs interfaces vs delegates vs virtuals
- ↑→40种网页常用小技巧(javascript)←↓------[不时之需]- -
- 实现自动配置