資金歸集率sql

標籤：

暫時

select bd_glorgbook.glorgbookcode,
nvl(replace(bd_glorgbook.glorgbookname,‘集團基準賬薄‘,‘‘),‘小計‘)公司名稱, --從蘿蔔那裡學習

bd_accsubj.subjcode,bd_accsubj.subjname,
sum( case when gl_balance.year= ‘2012‘ then gl_balance.debitamount else 0 end) "2012發生額",
sum( case when gl_balance.year= ‘2013‘ then gl_balance.debitamount else 0 end) "2013發生額",
sum( case when gl_balance.year= ‘2014‘ then gl_balance.debitamount else 0 end) "2014發生額" ,
sum( case when gl_balance.year= ‘2015‘ then gl_balance.debitamount else 0 end) "2015發生額"

from gl_balance, bd_accsubj, bd_glorgbook
where gl_balance.pk_accsubj = bd_accsubj.pk_accsubj
and bd_glorgbook.pk_glorgbook = gl_balance.pk_glorgbook
and bd_glorgbook.glorgbookcode like ‘01%-0001‘
and (bd_accsubj.subjcode like ‘2123%‘ or bd_accsubj.subjcode like ‘1131%‘or bd_accsubj.subjcode like ‘1111%‘)
and gl_balance.period<>‘00‘
and gl_balance.year in(‘2012‘,‘2013‘,‘2014‘,‘2015‘)
group by bd_glorgbook.glorgbookcode, rollup((bd_accsubj.subjcode,bd_accsubj.subjname , bd_glorgbook.glorgbookname))

order by bd_glorgbook.glorgbookcode, bd_accsubj.subjcode

資金歸集率sql