select value1,last(value1) over()-first(value1) over() value2,value3 from
(select value1,value3 from table1 where....
union
select value4,value5 from table2 where...)
select value1,last(value1) over()-first(value1) over() value2,value3 from
(select value1,value3 from table1 where....
union
select value4,value5 from table2 where...)
sorry,用union all比较合适
select col_num from table where ...
union all
selcct last_value(col_num) over()-first_value(col_num) over() from table where ... and rownum=1;
select col_num from table where ...
union
selcct last_value(col_num) over(order by rownum)-first_value(col_num) over(order by rownum) from table where ... and rownum=1;