2014年3月12日
SQL server横表纵表相互转换
摘要： Name　CourseGrade张三yuwen75张三shuxue80李四yingyu90李四yuwen95李四shuxue55Nameyuwenshuxueyingyu张三758090李四95550纵表转横表select Name,sum(case Course when 'yuwen' then Grade else 0 end) as 'yuwen',sum(case Course when 'shuxue' then Grade else 0 end) as 'shuxue',sum(case Course when &# 阅读全文
posted @ 2014-03-12 11:33 棠哥仔 阅读(2066) 评论(0) 推荐(0)