select
fd1
,fd2
,MAX(DECODE(KBN,'1',fd3)) hfd31
,MAX(DECODE(KBN,'1',fd4)) hfd41
,MAX(DECODE(KBN,'2',fd3)) hfd32
,MAX(DECODE(KBN,'2',fd4)) hfd42from table
group by fd1,fd2;
select
fd1
,fd2
,MAX(DECODE(KBN,'1',fd3)) hfd31
,MAX(DECODE(KBN,'1',fd4)) hfd41
,MAX(DECODE(KBN,'2',fd3)) hfd32
,MAX(DECODE(KBN,'2',fd4)) hfd42from table
group by fd1,fd2;