面试中经常会遇到的一个SQL面试题,现在小虾与大家分享一下,我最近写出来的方法
SQL:select t1.姓名,数学,语文,英语,政治,物理 from (select 姓名,成绩 as 数学 from table1 where 课程='数学') as t1 inner join (select 姓名,成绩 as 英语 from table1 where 课程='英语') as t2 on t1.姓名=t2.姓名 inner join (select 姓名,成绩 as 政治 from table1 where 课程='政治') as t3 on t1.姓名=t3.姓名 inner join (select 姓名,成绩 as 物理 from table1 where 课程='物理') as t4 on t1.姓名=t4.姓名 inner join (select 姓名,成绩 as 语文 from table1 where 课程='语文') as t5 on t1.姓名=t5.姓名