|
with t as(select level-1 l from dual connect by level<=101)
,a as(select t.l,t1.l,t2.l,t3.l from t,t t1,t t2,t t3
where t.l*t3.l + t1.l*(t3.l+1)+t2.l*(t3.l+2)=100
and t.l>0 and t3.l>0
)
select count(*) from a;
COUNT(*)
----------
1325
已用时间: 00: 00: 46.32
|
|