摘要：
1、纵表转横表：纵表结构 TableA横表结构 TableB方法一： 1: select Name， 2: sum(case Course when ‘语文‘ then Grade else 0 end) as 语文， 3: sum(case Course when ‘数学‘ then Grade else 0 end) as 数学， 4: sum(case Course when ‘英语‘ then Grade else 0 end) as 英语 5: from TableA 6: group by Name 7: 2、横表转纵表的"SQL"示例 横表结构: TE... 阅读全文
