oracle分组动态累加
sum(t.yjje) over( PARTITION by t.xh order by t.xh,substr(t.sfqjdm,1,4),t.sfqjmc,t.sfxmmc) as yjljje,--应
sum(t.sjje) over( PARTITION by t.xh order by t.xh,substr(t.sfqjdm,1,4),t.sfqjmc,t.sfxmmc) as sjjnljje,--实
sum(t.qfje) over( PARTITION by t.xh order by t.xh,substr(t.sfqjdm,1,4),t.sfqjmc,t.sfxmmc) as qjljje
oracle 空字符串与null过滤
nvl(trim(b.hyzh),'0')<>'0' and b.hyzh IS NOT NULL