mysql 列转行 unpivot_sql的行转列(PIVOT)与列转行(UNPIVOT)

一、行转列

1、测试数据准备

CREATE TABLE [StudentScores]

(

[UserName] NVARCHAR(20), --学生姓名

[Subject] NVARCHAR(30), --科目

[Score] FLOAT, --成绩

)

INSERT INTO [StudentScores] SELECT '张三', '语文', 80

INSERT INTO [StudentScores] SELECT '张三', '数学', 90

INSERT INTO [StudentScores] SELECT '张三', '英语', 70

INSERT INTO [StudentScores] SELECT '张三', '生物', 85

INSERT INTO [StudentScores] SELECT '李四', '语文', 80

INSERT INTO [StudentScores] SELECT '李四', '数学', 92

INSERT INTO [StudentScores] SELECT '李四', '英语', 76

INSERT INTO [StudentScores] SELECT '李四', '生物', 88

INSERT INTO [StudentScores] SELECT '码农', '语文', 60

INSERT INTO [StudentScores] SELECT '码农', '数学', 82

INSERT INTO [S