连续号码段

create table test (fphm number ,start_num number,end_num number )

insert into test values(2013,120,122)
insert into test values(2013,124,125)
insert into test values(2013,125,128)
insert into test values(2013,128,129)
insert into test values(2013,130,131) --再增加2个连续
insert into test values(2013,131,144)
insert into test values(2014,7,12)

commit

select   fphm,min(root) start_num,end_num
from     
     (select  fphm,end_num,
                 connect_by_root start_num root
      from    test a
      where connect_by_isleaf=1
      connect by start_Num=prior end_num
      and   fphm= fphm )
group by fphm,end_num
having count(1)<>1
order by 1


结果

fphm    start_num   end_num
2013    124             129
2013    130             144
请使用浏览器的分享功能分享到微信等