with tmp as ( select 'GSXSSL','销售数量' from daul union all select 'GSHSJJJE','含税进价金额' from daul union all select 'GSXSSR','销售收入' from daul ) select * from tmp
with tmp as ( select 'GSXSSL','销售数量' from dual union all select 'GSHSJJJE','含税进价金额' from dual union all select 'GSXSSR','销售收入' from dual ) select * from tmp
(
select 'GSXSSL','销售数量' from daul
union all
select 'GSHSJJJE','含税进价金额' from daul
union all
select 'GSXSSR','销售收入' from daul
)
select * from tmp
(
select 'GSXSSL','销售数量' from dual
union all
select 'GSHSJJJE','含税进价金额' from dual
union all
select 'GSXSSR','销售收入' from dual
)
select * from tmp