Transform Pivot Column

2

I'mtryingtoturnthecolumn"prtnum" yellow inline, I'm trying to use the PIVOT but I can not already tried it in some ways and it's not right:

Select 

 Distinct (ORD_LINE.ordnum),
 ORD_LINE.prtnum,
 Sum (ORD_LINE.ordqty)

From ORD_LINE


Where 
ORD_LINE.entdte >= trunc (sysdate, 'MM')

Group By ORD_LINE.ordnum,ORD_LINE.prtnum
    
asked by anonymous 18.07.2016 / 18:35

0 answers