淘先锋技术网

首页 1 2 3 4 5 6 7
Pl/sql 编程之case when的用法:(t3.LOCAL_BF_KND='111000' -- 本月基本月租费
select sum(t1.FAV_FEE) from bi_rw.FO_A_2FAV_M_G t1, bi_rw.D_BILLFEE_KND t3 where t1.BILLFEE_KND=t3.BILLFEE_KND(+) and t3.LOCAL_BF_KND='111000'  --1310557.76
 
如果不便于把条件t3.LOCAL_BF_KND='111000' 写在where条件中,则需要使用case when 语言来限定条件:
select sum(case when t3.LOCAL_BF_KND='111000' then t1.FAV_FEE else 0 end )    from bi_rw.FO_A_2FAV_M_G t1, bi_rw.D_BILLFEE_KND t3
where t1.BILLFEE_KND = t3.BILLFEE_KND(+)
--1310557.76