目录
0 需求
如下:
1 数据准备
create table t1 as
select '1' as id ,'mike' as name ,'22' as age,'0' as gender
union all
select '2' as id ,'kangkang' as name ,'19' as age,'1' as gender
2 数据分析
(1)使用union的方法进行行转列
select id,'name' as type,name as value
from t1
union all
select id,'age' as type,age as value
from t1
union all
select id,'gender' as type,gender as value
from t1
ord