看错了
select 字段1,
row_number() over (order by sum(字段2) desc Fink
from (
select * from mo_200503
union
select * from mo_200504
)
where Fink between 2 and 8
呵呵,这可不行
select * from mo_200504
where 字段1 in
(select 字段1
from (select 字段1,
row_number() over (order by sum(字段2) desc) fank
from mo_200503
where fank=2)
)
select * from (select a.*,rownum t from mo_200503 a union select b.*,rownum+(select count(1) from mo_200503) t from mo_200504 b) where t between 2 and 8