Pivot sql

Hi All, I need help with a sql on how to write a pivot sql for the working sql. SELECT DEPTID,JRNL_LINE_SOURCE, SUM(MONETARY_AMOUNT) 'Sum Amount' FROM PS_JRNL_LN WHERE BUSINE...

olafhelper

Jun 28, 2021

rameshdv , an easy way is to use conditional summing, like

select Dept, 
       sum(case when Type = 'GAP' THEN MONETARY_AMOUNT ELSE 0.0 END) AS Gap,
       sum(case when Type = 'GEX' THEN MONETARY_AMOUNT ELSE 0.0 END) AS Gex
from yourTable
where ..
group by Dept

olafhelper

Bronze Contributor

Jun 28, 2021

rameshdv , an easy way is to use conditional summing, like

select Dept, 
       sum(case when Type = 'GAP' THEN MONETARY_AMOUNT ELSE 0.0 END) AS Gap,
       sum(case when Type = 'GEX' THEN MONETARY_AMOUNT ELSE 0.0 END) AS Gex
from yourTable
where ..
group by Dept

rameshdv

Copper Contributor

Jun 29, 2021

Hi olafhelper,
Thanks a lot for the help.

Forum Discussion

Pivot sql