WITH    data
          AS ( SELECT   ‘语文‘ subject_name ,
                        90 score ,
                        ‘张三‘ student_name ,
                        ‘一班‘ class_name
               UNION ALL
               SELECT   ‘数学‘ subject_name ,
                        92 score ,
                        ‘张三‘ student_name ,
                        ‘一班‘ class_name
               UNION ALL
               SELECT   ‘英语‘ subject_name ,
                        93 score ,
                        ‘张三‘ student_name ,
                        ‘一班‘ class_name
               UNION ALL
               SELECT   ‘语文‘ subject_name ,
                        89 score ,
                        ‘张三1‘ student_name ,
                        ‘一班‘ class_name
               UNION ALL
               SELECT   ‘数学‘ subject_name ,
                        82 score ,
                        ‘张三1‘ student_name ,
                        ‘一班‘ class_name
               UNION ALL
               SELECT   ‘英语‘ subject_name ,
                        81 score ,
                        ‘张三1‘ student_name ,
                        ‘一班‘ class_name
               UNION ALL
               SELECT   ‘英语‘ subject_name ,
                        91 score ,
                        ‘张三1‘ student_name ,
                        ‘一班‘ class_name
             )
    SELECT  *
    FROM    data PIVOT( MAX(score) FOR subject_name IN ( [语文], [数学], [英语] ) ) t;