解决方案 »
- 难度sql查询题,高手进!
- dbca创建第二个数据库和例程
- 这个instead of 触发器有问题吗,郁闷!
- 9i安装后,Enterprise Manager Console 不能启动,请各位给小弟解惑
- 求SQL存储过程语句,很简单的,初次在ORACLE里写,和SQL SERVER不一样
- Help! 谁有Object browser 的英文注册版阿?
- 如何将Oracle8 导出的数据导入到Oracle8i中,急!!!
- 菜鸟提问:在ORACLE下如何建立关联
- 请问PL/SQL与SQL查询哪个更快!
- 使用SQL*PLUS的问题
- 注册表中没有找不到nls_lang怎么修改客户端字符集
- oracle 11g for redhat 安装后 系统中没有sysman用户
select id,sum(ids) AS summ from
(select id,state_code,ids
from (select bzh AS ID,
decode(dzrq1,null,0,'注销',0,jfgz1) jfgz1 ,
decode(dzrq2,null,0,'注销',0,jfgz2) jfgz2 ,
decode(dzrq3,null,0,'注销',0,jfgz3) jfgz3 ,
decode(dzrq4,null,0,'注销',0,jfgz4) jfgz4 ,
decode(dzrq5,null,0,'注销',0,jfgz5) jfgz5 ,
decode(dzrq6,null,0,'注销',0,jfgz6) jfgz6 ,
decode(dzrq7,null,0,'注销',0,jfgz7) jfgz7 ,
decode(dzrq8,null,0,'注销',0,jfgz8) jfgz8 ,
decode(dzrq9,null,0,'注销',0,jfgz9) jfgz9 ,
decode(dzrq10,null,0,'注销',0,jfgz10) jfgz10 ,
decode(dzrq11,null,0,'注销',0,jfgz11) jfgz11 ,
decode(dzrq12,null,0,'注销',0,jfgz12) jfgz12
from B) t
unpivot
(
ids
for state_code in ("JFGZ1","JFGZ2","JFGZ3","JFGZ4","JFGZ5","JFGZ6","JFGZ7","JFGZ8"
,"JFGZ9","JFGZ10","JFGZ11","JFGZ12")
)
) where ids <>0 group by ID)S
WHERE A.Gzlj!=S.summ