摘要:
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 阅读全文