b3.sql

来自「一个较好的公务员管理系统软件源代码」· SQL 代码 · 共 26 行

/*******************************
--创建劳动保障公务组织统计表视图22b3
*******************************/
--第一列
select 1 xh,sum(decode(zjlb,'01',1,0)) row1,sum(decode(zjlb||qx,'01001',1,0)) row2
			,sum(decode(zjlb,'01',decode(qx,'001',0,1),0)) row3
	from v_a4_1
 where 1=1
/
--第二列
select 2 xh,sum(decode(zjlb,'02',1,0)) row1,sum(decode(zjlb||qx,'02001',1,0)) row2
			,sum(decode(zjlb,'02',decode(qx,'001',0,1),0)) row3
	from v_a4_1
 where 1=1
/
--第三列
select 3 xh,sum(1) row1,sum(decode(pxbm,'001',1,'321',1,0)) row2,sum(decode(pxbm,'001',0,'321',0,1)) row3
	from v_a4_2
 where 1=1
/
--第四列
select 4 xh,sum(pxrs) row1,sum(decode(pxbm,'001',pxrs,'321',pxrs,0)) row2,sum(decode(pxbm,'001',0,'321',0,pxrs)) row3
	from v_a4_2
 where 1=1
/