select c_name,
sum(decode(month,'JAN',po_no,0)),
sum(decode(month,'FEB',po_no,0)),
.
.
.
sum(decode(month,'DEC',po_no,0))
from mytable
group by c_name
|
Results 1 to 4 of 4
Thread: Matrix QueryThreaded View
|
Click Here to Expand Forum to Full Width |