摘要:
数据库是sqlserver的话执行:select b.stu_name,max(case a.subject when '语文' then a.grade else '' end) as 语文, max(case a.subject when '数学' then a.grade else '' end) as 数学, max(case a.subject when '英语' then a.grade else '' end) as 英语from stu_grade a,stu_master bwhe 阅读全文