oracle中求一sql

Question

已知表GLUE，其中YMONTH的值是年月， Y_WEEK的值只能是1、2、3、4、5W_ID     W_PRICE                   YMONTH            Y_WEEK
1              1.1               200901             1
2              1.2               200901             2
3              1.3               200901             3
4              1.4               200902             1
5              1.5               200903             2
6              1.6               200905             1
7              1.7               200905            3
8              1.8               200906            1
9              1.9               200907             4
10            1.10               200908             4
11            1.1 1               200909             4
12            1.12                200910             3
13            1.13                200911             5
14            1.14                200911             5
现要得到如下数据：（）
年月/周    1   2  3   4  5  6  7  8  9  10  11  12----->  YMONTH  
1          
2             得到的值是w_price
3
4
5
Y_WEEK

Answer 1

行转列
select y_week,
  sum(decode(YMONTH,'200901',w_price))"200901",
  sum(decode(YMONTH,'200902',w_price))"200902",
....
from GLUE
group by y_week动态的话参照
http://topic.csdn.net/u/20091019/11/67cd55a3-3f42-4db7-a3f8-91dd52a913cd.html
max改成sum

Answer 2

得到的结果中的YMONTH年份怎么不见了

Answer 3

UP,行转列很常见的，用CASE WHEN 或DECODE子句。