|
9#
答案为 6
N=100,1000,10000
SQL> with t as (select level n from dual connect by level <= 100),
2 s as (select a.n
3 from t a,t b
4 where a.n >= 2*b.n
5 and mod(a.n,b.n) = 0
6 group by a.n
7 having sum(b.n) > a.n)
8 select max(gap) from ( select nvl(lead(n) over(order by n),0) - n as gap from s)
9 /
MAX(GAP)
----------
6
SQL>
SQL> with t as (select level n from dual connect by level <= 1000),
2 s as (select a.n
3 from t a,t b
4 where a.n >= 2*b.n
5 and mod(a.n,b.n) = 0
6 group by a.n
7 having sum(b.n) > a.n)
8 select max(gap) from ( select nvl(lead(n) over(order by n),0) - n as gap from s)
9 /
MAX(GAP)
----------
6
SQL>
SQL> with t as (select level n from dual connect by level <= 10000),
2 s as (select a.n
3 from t a,t b
4 where a.n >= 2*b.n
5 and mod(a.n,b.n) = 0
6 group by a.n
7 having sum(b.n) > a.n)
8 select max(gap) from ( select nvl(lead(n) over(order by n),0) - n as gap from s)
9 /
MAX(GAP)
----------
6 |
|