请各位大哥指教,如何将这段sqlserver写的sql语句转换成相应的oracle
select a.xm as XM,b.dwmc as GZDW,c.bmmc as GZBM,d.bmmc as GZBM2,SUM(CASE e.FLZL WHEN 'QD01' THEN e.YFS ELSE 0 END) AS JTF,
SUM(CASE e.FLZL WHEN 'QD02' THEN e.YFS ELSE 0 END) AS TXF,
SUM(CASE e.FLZL WHEN 'QD03' THEN e.YFS ELSE 0 END) AS LYF,
SUM(CASE e.FLZL WHEN 'QD99' THEN e.YFS ELSE 0 END) AS QT
from t_jbxx_jbxx a,t_zzjg_dwzz b,
t_zzjg_bmsz c,t_zzjg_bmsz d,t_cwsj_ygxzxx e where a.gzdw=b.dwdm and a.gzbm=c.bmdm and a.gzbm2=d.bmdm and a.ryid*=e.ryid
and a.gzdw='AA01'
group by a.xm,b.dwmc,c.bmmc,d.bmmc order by gzdw,gzbm,gzbm2,xm
主要是case这一段的写法!谢谢了!