多行转多列并且分组合并列

select group_code,max(group_name),sku_code,max(decode(type,'1',relevancy_sku,'')),
 listagg(decode(type,'2',relevancy_sku,''), ',') within group (order by relevancy_sku)
,max(decode(type,'3',relevancy_sku,'')),max(decode(type,'99',relevancy_sku,'')) 
,max(creator),max(create_date),max(modify_date) from s_sku_relevancy  
GROUP BY group_code, sku_code order by max(create_date) desc