select year, max(decode(rn,1,season)) 季节1, max(decode(rn,2,season)) 季节2, max(decode(rn,3,season)) 季节3, max(decode(rn,4,season)) 季节4 from( select year,season, row_number()over(partition by year order by decode(season,'spring',1,'summer',2,'automn',3,'winter',4)) rn from A )group by year
max(decode(rn,1,season)) 季节1,
max(decode(rn,2,season)) 季节2,
max(decode(rn,3,season)) 季节3,
max(decode(rn,4,season)) 季节4
from(
select year,season,
row_number()over(partition by year order by decode(season,'spring',1,'summer',2,'automn',3,'winter',4)) rn
from A
)group by year