怎么取得ORACLE数据库表中一个连续的序列字段中最小的空号

Question

几天不见，楼上的升星了
up

Answer 1

08:39:55 SQL> select tb.*,lag(col1,1,0) over(order by col1) lag from tb;COL1       COL2                           COLNEW               LAG
---------- ------------------------------ -------------------- ----------
1          aaa                            aaa                  0
2          aaa                            aaa                  1
3          aaa                            aaa                  2
4          bba                            bba                  3
5          bbb                            bbb                  4
8          bbb                            ccc                  5已选择6行。已用时间:  00: 00: 00.16
08:39:57 SQL> select lag+1 from (
08:40:23   2  select tb.*,lag(col1,1,0) over(order by col1) lag from tb
08:40:28   3  ) t where col1-lag>1;     LAG+1
----------
         6已用时间:  00: 00: 00.15
08:40:47 SQL>