|
lastwinner 发表于 2012-5-11 00:22 ![]()
汗,没注意
select 2+5+14+3+6+12+4+7+13+1 FROM DUAL;
67,这个更小,检查了没问题
写了个很笨的sql,在我的笔记本上跑了90分钟才跑出结果,而且加了N多限制条件,比如首尾必须是1和2、总和不超过67(因为手工已经验证出一个67的结果了)- with t as(select level n from dual connect by level<=18)
- select t1.n,t2.n,t3.n,t4.n,t5.n,t6.n,t7.n,t8.n,t9.n,t0.n from
- t t1,t t2,t t3,t t4,t t5,t t6,t t7,t t8,t t9,t t0
- where t1.n+t2.n+t3.n+t4.n+t5.n+t6.n+t7.n+t8.n+t9.n+t0.n between 55 and 67
- and t1.n+t2.n+t3.n>=21 and t2.n+t3.n+t4.n>=21 and t3.n+t4.n+t5.n>=21
- and t4.n+t5.n+t6.n>=21 and t5.n+t6.n+t7.n>=21 and t6.n+t7.n+t8.n>=21
- and t7.n+t8.n+t9.n>=21 and t8.n+t9.n+t0.n>=21 and t1.n=2
- and t2.n not in (1,t1.n)
- and t3.n not in (1,t1.n,t2.n)
- and t4.n not in (1,t1.n,t2.n,t3.n)
- and t5.n not in (1,t1.n,t2.n,t3.n,t4.n)
- and t6.n not in (1,t1.n,t2.n,t3.n,t4.n,t5.n)
- and t7.n not in (1,t1.n,t2.n,t3.n,t4.n,t5.n,t6.n)
- and t8.n not in (1,t1.n,t2.n,t3.n,t4.n,t5.n,t6.n,t7.n)
- and t9.n not in (1,t1.n,t2.n,t3.n,t4.n,t5.n,t6.n,t7.n,t8.n)
- and t0.n =1
- order by t1.n+t2.n+t3.n+t4.n+t5.n+t6.n+t7.n+t8.n+t9.n+t0.n asc
复制代码 得到的结果是总共124行
第一行的各数之和是67,说明最小应该是67 |
|