填数字游戏

〇〇

10楼并假定每个菱形小面数字小于下面

jmyhyu

假定从上到下，每行从左到右依次是 1 2 3 4 5 6 7 8 9 10 with t1 as(select level l from dual connect by level 〇〇 发表于 2009-12-2 13:55

903？错了吧 903%144≠0 你用SQL？

〇〇

错了,没有考虑各不相同这个条件

〇〇

with t as(select level l from dual connect by level<=10) /* x9=7-x2,x6=17-x5*/ select * from( select x1.l x1, x2.l x2, x3.l x3, x4.l x4, x5.l x5, 17-x5.l x6, x7.l x7, x8.l x8, 7-x2.l x9, x10.l x10 from t x1,t x2,t x3,t x4,t x5,/*t x6,*/t x7,t x8,/*t x9,*/t x10 where x1.l+x4.l+x5.l+x8.l=24 and x2.l+x5.l+17-x5.l+x8.l=24 and x3.l+17-x5.l+x7.l+x10.l=24 and x1.l0 and (x2-x1)*(x2-x3)*(x2-x4)*(x2-x5)*(x2-x6)*(x2-x7)*(x2-x8)*(x2-x9)*(x2-x10)<>0 and (x3-x2)*(x3-x1)*(x3-x4)*(x3-x5)*(x3-x6)*(x3-x7)*(x3-x8)*(x3-x9)*(x3-x10)<>0 and (x4-x2)*(x4-x3)*(x4-x1)*(x4-x5)*(x4-x6)*(x4-x7)*(x4-x8)*(x4-x9)*(x4-x10)<>0 and (x5-x2)*(x5-x3)*(x5-x4)*(x5-x1)*(x5-x6)*(x5-x7)*(x5-x8)*(x5-x9)*(x5-x10)<>0 and (x6-x2)*(x6-x3)*(x6-x4)*(x6-x5)*(x6-x1)*(x6-x7)*(x6-x8)*(x6-x9)*(x6-x10)<>0 and (x7-x2)*(x7-x3)*(x7-x4)*(x7-x5)*(x7-x6)*(x7-x1)*(x7-x8)*(x7-x9)*(x7-x10)<>0 and (x8-x2)*(x8-x3)*(x8-x4)*(x8-x5)*(x8-x6)*(x8-x7)*(x8-x1)*(x8-x9)*(x8-x10)<>0 and (x9-x2)*(x9-x3)*(x9-x4)*(x9-x5)*(x9-x6)*(x9-x7)*(x9-x8)*(x9-x1)*(x9-x10)<>0 and (x10-x2)*(x10-x3)*(x10-x4)*(x10-x5)*(x10-x6)*(x10-x7)*(x10-x8)*(x10-x9)*(x10-x1)<>0 and rownum<=10;

〇〇

with t as(select level l from dual connect by level<=10) /* x9=7-x2,x6=17-x5*/ select * from( select x1.l x1, x2.l x2, x3.l x3, x4.l x4, x5.l x5, 17-x5.l x6, x7.l x7, x8.l x8, 7-x2.l x9, x10.l x10 from t x1,t x2,t x3,t x4,t x5,/*t x6,*/t x7,t x8,/*t x9,*/t x10 where x1.l+x4.l+x5.l+x8.l=24 and x2.l+x5.l+17-x5.l+7-x2.l=24 and x3.l+17-x5.l+x7.l+x10.l=24 and x1.l0 and (x2-x1)*(x2-x3)*(x2-x4)*(x2-x5)*(x2-x6)*(x2-x7)*(x2-x8)*(x2-x9)*(x2-x10)<>0 and (x3-x2)*(x3-x1)*(x3-x4)*(x3-x5)*(x3-x6)*(x3-x7)*(x3-x8)*(x3-x9)*(x3-x10)<>0 and (x4-x2)*(x4-x3)*(x4-x1)*(x4-x5)*(x4-x6)*(x4-x7)*(x4-x8)*(x4-x9)*(x4-x10)<>0 and (x5-x2)*(x5-x3)*(x5-x4)*(x5-x1)*(x5-x6)*(x5-x7)*(x5-x8)*(x5-x9)*(x5-x10)<>0 and (x6-x2)*(x6-x3)*(x6-x4)*(x6-x5)*(x6-x1)*(x6-x7)*(x6-x8)*(x6-x9)*(x6-x10)<>0 and (x7-x2)*(x7-x3)*(x7-x4)*(x7-x5)*(x7-x6)*(x7-x1)*(x7-x8)*(x7-x9)*(x7-x10)<>0 and (x8-x2)*(x8-x3)*(x8-x4)*(x8-x5)*(x8-x6)*(x8-x7)*(x8-x1)*(x8-x9)*(x8-x10)<>0 and (x9-x2)*(x9-x3)*(x9-x4)*(x9-x5)*(x9-x6)*(x9-x7)*(x9-x8)*(x9-x1)*(x9-x10)<>0 and (x10-x2)*(x10-x3)*(x10-x4)*(x10-x5)*(x10-x6)*(x10-x7)*(x10-x8)*(x10-x9)*(x10-x1)<>0 / X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- 5 1 2 4 7 10 9 8 6 3 4 1 2 5 7 10 9 8 6 3 4 1 2 8 7 10 9 5 6 3 5 1 2 4 8 9 10 7 6 3 4 1 2 5 8 9 10 7 6 3 4 1 2 7 8 9 10 5 6 3 6 2 1 3 7 10 9 8 5 4 3 2 1 6 7 10 9 8 5 4 3 2 1 8 7 10 9 6 5 4 6 2 1 3 8 9 10 7 5 4 3 2 1 6 8 9 10 7 5 4 3 2 1 7 8 9 10 6 5 4 5 1 2 3 7 10 8 9 6 4 3 1 2 5 7 10 8 9 6 4 5 1 2 3 9 8 10 7 6 4 3 1 2 5 9 8 10 7 6 4 3 1 2 7 9 8 10 5 6 4 6 3 1 2 7 10 8 9 4 5 2 3 1 6 7 10 8 9 4 5 6 3 1 2 9 8 10 7 4 5 2 3 1 6 9 8 10 7 4 5 2 3 1 7 9 8 10 6 4 5 4 1 3 2 8 9 7 10 6 5 2 1 3 4 8 9 7 10 6 5 4 1 3 2 10 7 9 8 6 5 2 1 3 4 10 7 9 8 6 5 2 1 3 8 10 7 9 4 6 5 3 1 4 2 9 8 7 10 6 5 2 1 4 3 9 8 7 10 6 5 3 1 4 2 10 7 8 9 6 5 2 1 4 3 10 7 8 9 6 5 5 3 2 1 8 9 7 10 4 6 1 3 2 5 8 9 7 10 4 6 5 3 2 1 10 7 9 8 4 6 1 3 2 5 10 7 9 8 4 6 1 3 2 8 10 7 9 5 4 6 4 2 3 1 9 8 7 10 5 6 1 2 3 4 9 8 7 10 5 6 4 2 3 1 10 7 8 9 5 6 1 2 3 4 10 7 8 9 5 6 5 3 2 1 8 9 6 10 4 7 1 3 2 5 8 9 6 10 4 7 4 1 3 2 8 9 5 10 6 7 2 1 3 4 8 9 5 10 6 7 4 2 3 1 9 8 6 10 5 7 1 2 3 4 9 8 6 10 5 7 3 1 4 2 9 8 5 10 6 7 2 1 4 3 9 8 5 10 6 7 4 1 5 2 8 9 3 10 6 7 3 1 5 2 9 8 4 10 6 7 2 1 5 3 9 8 4 10 6 7 4 2 6 1 9 8 3 10 5 7 5 3 6 1 8 9 2 10 4 7 6 3 1 2 7 10 5 9 4 8 5 1 2 3 7 10 4 9 6 8 4 2 3 1 10 7 6 9 5 8 1 2 3 4 10 7 6 9 5 8 3 1 4 2 10 7 5 9 6 8 2 1 4 3 10 7 5 9 6 8 3 1 5 2 10 7 4 9 6 8 2 1 5 3 10 7 4 9 6 8 4 2 6 1 10 7 3 9 5 8 6 2 1 3 7 10 4 8 5 9 5 3 2 1 10 7 6 8 4 9 1 3 2 5 10 7 6 8 4 9 4 1 3 2 10 7 5 8 6 9 2 1 3 4 10 7 5 8 6 9 4 1 5 2 10 7 3 8 6 9 5 3 6 1 10 7 2 8 4 9 6 2 1 3 8 9 4 7 5 10 6 3 1 2 9 8 5 7 4 10 5 1 2 3 9 8 4 7 6 10 72 rows selected.

〇〇

with t as(select level l from dual connect by level<=10) /* x9=7-x2,x6=17-x5*/ select * from( select x1.l x1, x2.l x2, x3.l x3, x4.l x4, x5.l x5, 17-x5.l x6, x7.l x7, x8.l x8, 7-x2.l x9, x10.l x10 from t x1,(select l from t where l in(1,2,3))x2,t x3,t x4, (select l from t where l in(7,8)) x5,/*t x6,*/t x7,t x8,/*t x9,*/t x10 where x1.l+x4.l+x5.l+x8.l=24 and x2.l+x5.l+17-x5.l+7-x2.l=24 and x3.l+17-x5.l+x7.l+x10.l=24 and x1.l0 and (x2-x3)*(x2-x4)*(x2-x5)*(x2-x6)*(x2-x7)*(x2-x8)*(x2-x9)*(x2-x10)<>0 and (x3-x4)*(x3-x5)*(x3-x6)*(x3-x7)*(x3-x8)*(x3-x9)*(x3-x10)<>0 and (x4-x5)*(x4-x6)*(x4-x7)*(x4-x8)*(x4-x9)*(x4-x10)<>0 and (x5-x6)*(x5-x7)*(x5-x8)*(x5-x9)*(x5-x10)<>0 and (x6-x7)*(x6-x8)*(x6-x9)*(x6-x10)<>0 and (x7-x8)*(x7-x9)*(x7-x10)<>0 and (x8-x9)*(x8-x10)<>0 and (x9-x10)<>0 /

dobear

居然有用SQL解决的，

trisinker

6*6*6*4=864 种