SQL进阶技巧：如何不使用union all 进行行转列

目录

0 需求

1 数据准备

2 数据分析

 3 小结

---

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 a