TRY IT ..
SELECT A.APPLYDEPT,
NVL(SUM(DECODE(A.IPLACE,'一廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS TP,
NVL(SUM(DECODE(A.IPLACE,'二廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS KS,
NVL(SUM(DECODE(A.IPLACE,'三廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS SZ,
NVL(SUM(DECODE(A.IPLACE,'四廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS SJ
FROM AFU_FORM_ISR A;
SELECT A.APPLYDEPT,
NVL(SUM(DECODE(A.IPLACE,'一廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS TP,
NVL(SUM(DECODE(A.IPLACE,'二廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS KS,
NVL(SUM(DECODE(A.IPLACE,'三廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS SZ,
NVL(SUM(DECODE(A.IPLACE,'四廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS SJ
FROM AFU_FORM_ISR A;
解决方案 »
- oracle 9i R2安装问题
- 诡异的数据问题
- PL/SQL developer 无法连接oracle9i的数据库
- 跪求大虾赐招。。。入门问题,安装后不能连接。。。。
- oralce中函数调用问题?在线等待!!
- 临时表问题
- 登陆问题,在独立启动的时候可以用sys,system,以sysdba身份登陆,但是登陆到oms后用sys,system却不能用sysdba身份
- 请问exist语句的效率问题
- 总是对oracle中的“数据库”这个概念无法理解
- 简单的问题.都给分的,在客户端和服务器端的程序配通后,客户机上的应用程序如何能够配好连上服务器?
- 一个预编译语句插入日期查询的问题
- sqlplus怎么插不进记录呢
楼上SQL加入DISTINCT排重后得到正确结果。
SELECT DISTINCT A.APPLYDEPT,
NVL(SUM(DECODE(A.IPLACE,'一廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS TP,
NVL(SUM(DECODE(A.IPLACE,'二廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS KS,
NVL(SUM(DECODE(A.IPLACE,'三廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS SZ,
NVL(SUM(DECODE(A.IPLACE,'四廠',1,0)) OVER(PARTITION BY A.APPLYDEPT),'0') AS SJ
FROM AFU_FORM_ISR A;
结帖。