本文介绍了一个使用SQL进行数据转换的具体案例。通过创建表格并插入学生分数数据，演示了如何将行数据转换为列数据的过程。该操作对于数据分析和报告特别有用。
CREATE TABLE Score(StuNo varchar(10), StuName varchar(50), CourseName varchar(50),
Score int);
GO
INSERT INTO Score
(StuNo, StuName, CourseName, Score)
VALUES ('1', 'Tom', 'Math', 80);
INSERT
INTO Score(StuNo, StuName, CourseName, Score)
VALUES ('1', 'Tom', 'English', 82);
INSERT
INTO Score(StuNo, StuName, CourseName, Score)
VALUES ('1', 'Tom', 'Geography', 84);
INSERT
INTO Score(StuNo, StuName, CourseName, Score)
VALUES ('2', 'Jone', 'Math', 79);
INSERT
INTO Score(StuNo, StuName, CourseName, Score)
VALUES ('2', 'Jone', 'English', 88);
INSERT
INTO Score(StuNo, StuName, CourseName, Score)
VALUES ('2', 'Jone', 'Geography', 86);
GO
--行转换成列
SELECT StuNo, StuName, Math, English, Geography
FROM Score PIVOT (MAX(Score) FOR CourseName IN (Math, English, Geography))
AS ScoreList
ORDER BY StuNo;
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
