How can I realize the interchange between row and column in a SQL statement?

zhouhaiming · #1 (**permalink**) 08-16-04, 23:30

example:

month value
＝＝＝＝＝＝＝＝＝＝＝
10 100
11 200
12 205

10 11 12
＝＝＝＝＝＝＝＝＝＝＝
100 200 205

sathyaram_s · #2 (**permalink**) 08-17-04, 04:16

If it is a month-value pair, you may use

select sum(case month when 1 then value end) as 1,
sum(case month when 2 then value end) as 2,
....
....
sum(case month when 12 then value end) as 12
from table1

HTH

sathyaram

zhouhaiming · #3 (**permalink**) 08-18-04, 04:39

That's right!! Thank you very much!

Internet Services

Web Development

Digital Marketing

Consumer Tech