- 注册时间
- 2009-7-21
- 最后登录
- 1970-1-1
- 威望
- 星
- 金币
- 枚
- 贡献
- 分
- 经验
- 点
- 鲜花
- 朵
- 魅力
- 点
- 上传
- 次
- 下载
- 次
- 积分
- 4489
- 在线时间
- 小时
|
发表于 2009-12-2 20:12:09
|
显示全部楼层
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.l<x8.l and x3.l<x10.l
)
where
(x1-x2)*(x1-x3)*(x1-x4)*(x1-x5)*(x1-x6)*(x1-x7)*(x1-x8)*(x1-x9)*(x1-x10)<>0 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
/ |
评分
-
查看全部评分
|