select v0.f1 as new_f1, 
       (
         select min(f1)
           from sqf_test v2
          where v2.f1 > v0.f1
       ) new_f2,
       v1.f2 as new_f3
  from sqf_test v0
 cross join
       (
         select f2
           from sqf_test
          where f1 = (select min(f1) from sqf_test) 
       ) v1

select v1.f1 as new_f1,
       v2.f1 as new_f2,
       v1.f2 as new_f3,
       v2.f2 as new_f4
  from (
         select f1, f2,
                (
                  select count( 1 )
                    from sqf_test v3
                   where v0.f1 >= v3.f1
                ) rn
           from sqf_test v0 where rownum >=  1 
       ) v1
  left outer join
      (
         select f1, f2,
                (
                  select count( 1 )
                    from sqf_test v3
                   where v0.f1 >= v3.f1
                ) rn
           from sqf_test v0 where rownum >=  1 
       ) v2
    on v1.rn = v2.rn -  1 
 where v1.rn %  2  =  1 

select t1.f1 as new_f1, 
       min(t2.f1) as new_f2, 
       t1.f2 as new_f3
  from sqf_table t1
  left outer join
       sqf_table t2
    on t1.f1 < t2.f1
 group by t1.f1, t1.f2

select t1.f1 as new_f1, 
       min(t2.f1) as new_f2, 
       t1.f2 as new_f3,
       min(t2.f2) as new_f4 -- тут нужно немного доделать, иначе в общем случае будет выдавать фигню...
  from sqf_table t1
  left outer join
       sqf_table t2
    on t1.f1 < t2.f1
 group by t1.f1, t1.f2
having count(t2.f1) %  2  =  1