select a1,a2+100 a21,a2+a1 a22 ,a2+a3 a23 ,a3 from a;???????
select a1,max(decode(rm,1,a2)) a21 ,max(decode(rm,2,a2)) a22 ,max(decode(rm,3,a2)) a23 ,..... from (select a1,a2,row_number() over(partition by a1,a2 order by a2) rm,a3 from a) group by a1,a2
,max(decode(rm,2,a2)) a22
,max(decode(rm,3,a2)) a23
,.....
from
(select a1,a2,row_number() over(partition by a1,a2 order by a2) rm,a3 from a)
group by a1,a2