在EXECL中用SQL语句怎么去掉下面重复的标题行

xieyukun2003

SELECT * FROM (
SELECT *
FROM `D:\我的文档\桌面\考核批量导入.XLSX`.`'1$'` `'1$'` union all
SELECT *
FROM `D:\我的文档\桌面\考核批量导入.XLSX`.`'2$'` `'2$'` union all
SELECT *
FROM `D:\我的文档\桌面\考核批量导入.XLSX`.`'3$'` `'3$'` union all
SELECT *
FROM `D:\我的文档\桌面\考核批量导入.XLSX`.`'4$'` `'4$'` )
WHERE (`'1$'`.BUKRS <> ' ')

jiangxiaoyun

第二个表开始做限制，添加条件，where gjahr <>'财年'