1,纵表转横表纵表结构 Table_A:转换后的结构:纵表转横表的SQL示例:SELECT Name ,SUM(CASE WHEN Course = N'语文' THEN GradeELSE 0END) AS Ch