Just try it ..
SQL> select distinct send_nbr
2 from (
3 select send_nbr,
4 lead(receive_nbr,2,0) over(partition by send_nbr order by receive_nbr) - receive_nbr as lev
5 from trp_prize_user_bill tt
6 )zz
7 where lev = 2;SEND_NBR
--------
B
SQL> select distinct send_nbr
2 from (
3 select send_nbr,
4 lead(receive_nbr,2,0) over(partition by send_nbr order by receive_nbr) - receive_nbr as lev
5 from trp_prize_user_bill tt
6 )zz
7 where lev = 2;SEND_NBR
--------
B
上100W,现在运行出错:ORA-01722:invalid number.
replace(replace(receive_nbr,'-'),' ')