莫听穿林打叶声|何妨吟啸且徐行
数据在数据(仓)库中往往是以行的形式存储居多,一行就是一条记录,比如我们最常用的订单表,一条订单记录代表客户的某一次购买,这条记录会详细记录金额,成交时间等。
但是有的时候为了方便分析,需要把行形式的数据展开成列形式的。
本文主要就是介绍几种行转列的方法,以及我自己由浅入深的思考。
正文
Pre 数据准备
;WITH Student AS(SELECT '刘得华' AS Name ,'语文' AS Course,54 AS GradeUNION ALLSELECT '刘得华' AS Name ,'数学' AS Course,95 AS GradeUNION ALLSELECT '刘得华' AS Name ,'英语' AS Course,60 AS GradeUNION ALLSELECT '吴延祖' AS Name ,'语文' AS Course,98 AS GradeUNION ALLSELECT '吴延祖' AS Name ,'数学' AS Course,47 AS GradeUNION ALLSELECT '吴延祖' AS Name ,'英语' AS Course,75 AS Grade)SELECT * F