主题：求SQL取分的语句

 例子发上来

select 姓名, iif(语文 is null, iif(数学 is null, iif(英语 is null, 物理, 英语),数学),语文) as 分数 from (select 姓名, (select 分数 from {表A} as b where 课程 = '语文' and a.姓名 = b.姓名) as 语文, (select 分数 from {表A} as b where 课程 = '数学' and a.姓名 = b.姓名) as 数学, (select 分数 from {表A} as b where 课程 = '英语' and a.姓名 = b.姓名) as 英语, (select 分数 from {表A} as b where 课程 = '物理' and a.姓名 = b.姓名) as 物理 from {表A} as a group by 姓名) as c

 肯定的，哪有你这样取分数的？用sql语句不划算。