/*******************************
--創建勞動保障公務組織統計表視圖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
/