比如说id 3 和id 5 怎么找出他们间断层的数据id 4 ？不好意思是面试中问到的，实在是想不出怎么查询，
请有 oracle 工作经验的朋友帮忙分析下，谢谢
select t.* from
(select  row_number() over (order by OBJECT_ID desc nulls last) as row_number from DBA_OBJECTS ) t where t.row_number <=(select max(id) from test)
minus
SELECT A.id FROM test A

select id
from tableName start with id = 3 connect by id <5