oracle 列数据转成行数据

最新推荐文章于 2024-07-05 16:29:50 发布

Ybens0403

最新推荐文章于 2024-07-05 16:29:50 发布

阅读量239

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/halo-halo/p/9034848.html

版权

year	m1	m2	m3	m4
1991	1.1	1.2	1.3	1.4
1992	2.1	2.2	2.3	2.4

SELECT YEAR
    ,
    max( CASE WHEN rk = 1 THEN average ELSE NULL END ) AS m1,
    max( CASE WHEN rk = 2 THEN average ELSE NULL END ) AS m2,
    max( CASE WHEN rk = 3 THEN average ELSE NULL END ) AS m3,
    max( CASE WHEN rk = 4 THEN average ELSE NULL END ) AS m4 
FROM
    ( SELECT row_number ( ) over ( PARTITION BY year ORDER BY average ) rk FROM input_money ) t 
GROUP BY
YEAR