行列转换利器：Oracle pivot函数全面解析

1. SELECT
2.  *
3. FROM
4.  t_tuser pivot ( max( AGE ) FOR SEX IN ( '1' AS 男, '0' AS 女 ) )

1. SELECT
2.  id,
3.  max( decode( SEX, '1', AGE ) ) 男,
4.  max( decode( SEX, '0', AGE ) ) 女,
5.  sum(AGE) 总年龄
6. FROM
7.  t_tuser 
8. GROUP BY
9.  id

1. SELECT
2.  id,
3.  max(case when SEX = '1' then AGE end) 男, 
4. max(case when SEX = '0' then AGE end) 女, 
5.  sum(AGE) 总年龄
6. FROM
7.  t_tuser 
8. GROUP BY
9.  id