select * from (select * from test order by column_id) union all select 'test' from dual; --镶嵌一个子查询就能和union all连用