本文使用的方法:
1、用Case When
2、PIVOT函数
首先,模拟一张表:
-- 创建模拟数据
CREATE TABLE #TempSubjectResult
(
StudentName NVARCHAR(50) NOT NULL,
StudentSubject NVARCHAR(50) NOT NULL,
StudentGrade DECIMAL(4,1) NOT NULL
)
INSERT INTO #TempSubjectResult(StudentName,StudentSubject,StudentGrade) VALUES (小姚,语文,80)
INSERT INTO #TempSubjectResult(StudentName,StudentSubject,StudentGrade) VALUES (小姚,数学,70)
INSERT INTO #TempSubjectResult(StudentName,StudentSubject,StudentGrade) VALUES (小姚,英语,60)
INSERT INTO #TempSubjectResult(StudentName,StudentSubject,StudentGrade) VALUES (小明,语文,90)
INSERT INTO #TempSubjectResult(StudentName,StudentSubject,StudentGrade) VALUES (小明,数学,95)
INSERT INTO #TempSubjectResult(StudentName,StudentSubject,StudentGrade) VALUES (小明,英语,98)
SELECT * FROM #TempSubjectResult
表数据为:
----------------------------------
如果觉得《mysql 列转行不确定_SQL Server行转列 不确定列的行转列》对你有帮助,请点赞、收藏,并留下你的观点哦!