SELECT MC, NVL(pdjsl, 0) pdjsl, NVL(tpsl, 0) tpsl
FROM (SELECT T.MC, T.sblx_dm, T.YWL
FROM (SELECT c.dt_mc MC, b.sblx_dm, count(a.sbbm) YWL
FROM dt_sbjbxx A, dm_sblx B, dt_jbxx c
WHERE a.sblx_dm = B.sblx_dm
and a.dtjgdm = c.dt_dm
group by c.dt_mc, b.sblx_dm) T) PIVOT(SUM(YWL) FOR sblx_dm IN('05'
pdjsl,
'01' tpsl))
oracle行专列方法
最新推荐文章于 2024-07-31 14:31:55 发布