查比自己小，但是在比自己小的所有数据里面最大的记录

create table t as select * from dba_objects;

存放最后结果的表：

create table TT
(
  largeid NUMBER,
  smallid NUMBER
);

create or replace procedure test33 is
  Cursor cursor is
    select t1.object_id object_id from t t1 where t1.object_id > 2;
  t1           cursor%ROWTYPE;
  t2_object_id number;
begin
  for t1 in cursor LOOP
    begin
      select t3.object_id
        into t2_object_id
        from (select t2.*
                from t t2
               where t2.object_id < t1.object_id
               order by t2.object_id desc) t3
       where rownum = 1;
      insert into tt values (t1.object_id, t2_object_id);
    end;
  end Loop;
  commit;
end test33;

直接写sql去查，碰到了一些问题,下面是有问题的sql

select t1.object_id,
(select t3.object_id from (select t2.*  from t t2 where t2.object_id < t1.object_id order by t2.object_id desc ) t3 where rownum = 1) as lowobject_id,
t1.* from t t1 where object_id - lowobject_id > 1;

call test33();

查比自己小，但是在比自己小的所有数据里面最大的记录，并且比自己至少小2的记录

SELECT * FROM tt where tt.largeid > tt.smallid + 1 order by 1;