oracle 中查找不连续的数的最前一个值

select  min(max(content_code))+ 1 sr_no

from

(select t.content_code,

        t.content_code - row_number() over(order by content_code) diff

  from epp_t_content t

  where content_code between 12290 and 12299)

group by diff;

转载于:https://www.cnblogs.com/talk/archive/2011/12/29/2306672.html