SQL之pivot和unpivot的用法
pivot用于行转列,unpivot用于列转行
一、pivot 的语法:
select <non-pivoted column>, --非透视列
[first pivoted column] as <column name>, --透视列
[second pivoted column] as <column name>,
...
[last pivoted column] as <column name>
from table_name
pivot( <aggregation function> value_column)
for pivot_column in (<column_list>) )as <alias for pivot> --别名