晕,上传时候,我改文件名了,导致不能刷新,把文件名改为新建 Microsoft Excel 工作表.xlsx就可以了,或者重新引入数据,sql语句如下:
select b.姓名,a.* from (select id,max(成绩) as 最高分 from (select id,'语文' as 科目,语文 as 成绩 from [sheet2$] union all select id,'数学' as 科目,数学 as 成绩 from [sheet2$] union all select id,'英语' as 科目,英语 as 成绩 from [sheet2$]) group by id) a inner join [sheet1$] b on a.id=b.id