SQL语句中列转行案例

--初始化示例
DECLARE @StudentGrade TABLE(student VARCHAR(20), chinese int, maths int, english int)

INSERT @StudentGrade(student,chinese,maths,english)
VALUES('张三','98','76','89')

INSERT @StudentGrade(student,chinese,maths,english)
VALUES('李四','100','74','76')

INSERT @StudentGrade(student,chinese,maths,english)
VALUES('王五','87','90','71')

--原表查询
SELECT * FROM @StudentGrade

--列转行后查询
SELECT student,scoure,grade
FROM @StudentGrade
unpivot(grade FOR scoure in(chinese,maths,english))AS up

--结果如图