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
就是怎么查询oracle中间断层的数据?...谢谢
---看从这里可以收到启发不家里没数据库。。没测 ---Example(实现了日期的自动增长): select id from tableName start with id = 3 connect by id <5
谢谢你,我用你写的sql语句试试。
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 tablename) minus SELECT A.id FROM tablename A
sql code select id from tableName start with id = 3 connect by id <5
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
---看从这里可以收到启发不家里没数据库。。没测
---Example(实现了日期的自动增长):
select id
from tableName start with id = 3 connect by id <5
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 tablename)
minus
SELECT A.id FROM tablename A
select id
from tableName start with id = 3 connect by id <5