SqlServer2005 行转列,列转行
摘要:
class表数据class1表数据select [Student], [数学]=max(case when [Course]='数学' then [Score] else 0 end), [物理]=max(case when [Course]='物理' then [Score] else 0 end), [英语]=max(case when [Course]='英语' then [Score] else 0 end), [语文]=max(case when [Course]='语文' then [Score] else 0 end 阅读全文
posted @ 2011-12-28 12:03 BarneyZhang 阅读(584) 评论(0) 推荐(0) 编辑