year month amount
1991 1 1.1
1991 2 1.2
1991 3 1.3
1991 4 1.4
1992 1 2.1
1992 2 2.2
1992 3 2.3
1992 4 2.4
需要的结果:
y m1 m2 m3 m4
1991 1.1 1.2 1.3 1.4
1992 2.1 2.2 2.3 2.4
还请大虾帮忙呀!感激不尽!!!!!!!!!!
1991 1 1.1
1991 2 1.2
1991 3 1.3
1991 4 1.4
1992 1 2.1
1992 2 2.2
1992 3 2.3
1992 4 2.4
需要的结果:
y m1 m2 m3 m4
1991 1.1 1.2 1.3 1.4
1992 2.1 2.2 2.3 2.4
还请大虾帮忙呀!感激不尽!!!!!!!!!!
select year y,
sum(decode(month, 1, amount)) m1,
sum(decode(month, 2, amount)) m2,
sum(decode(month, 3, amount)) m3,
sum(decode(month, 4, amount)) m4
from t
group by year