ITPub博客

首页 > 数据库 > Oracle > statistics on double-color ball

statistics on double-color ball

原创 Oracle 作者:pentium 时间:2009-11-09 17:35:15 0 删除 编辑
some statistics on double-color ball[@more@]

09年:
16:
NOT IN (1,2,3,4,5,6,7,8,9) 4个以10开始,4个以11开始
2 link group: 4 (0个3 link)
1 link group: 9 (2个3 link)
none link: 3
11:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 8 (3个3 link)
1 link group: 2 (0个3 link)
none link: 1
15:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 2 (1个3 link)
1 link group: 9 (2个3 link)
none link: 4

-------------------------------------------
08年:
19:
NOT IN (1,2,3,4,5,6,7,8,9) 8个以10开始
2 link group: 6 (2个3 link)
1 link group: 10 (2个3 link)
none link: 3
13:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 1 (0个3 link)
1 link group: 8 (3个3 link)
none link: 4
16:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 4 (1个3 link)
1 link group: 7 (1个3 link)
none link: 5

-------------------------------------------
07年:
13:
NOT IN (1,2,3,4,5,6,7,8,9) 3个以10开始
2 link group: 2 (1个3 link)
1 link group: 9 (4个3 link)
none link: 2
9:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 2 (0个3 link)
1 link group: 5 (3个3 link)
none link: 2
15:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 3 (0个3 link)
1 link group: 9 (2个3 link)
none link: 2

-------------------------------------------
06年:
15:
NOT IN (1,2,3,4,5,6,7,8,9) 1个以10开始
2 link group: 2 (1个3 link)
1 link group: 11 (1个3 link)
none link: 3
13:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 4 (2个3 link)
1 link group: 6 (2个3 link)
none link: 3
14:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 4 (2个3 link)
1 link group: 6 (1个3 link)
none link: 4

-------------------------------------------
05年:
16:
NOT IN (1,2,3,4,5,6,7,8,9) 3个以10开始,5个以11开始
2 link group: 2 (2个3 link)
1 link group: 7 (2个3 link)
none link: 7
17:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 2 (0个3 link)
1 link group: 7 (0个3 link)
none link: 8
16:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 1 (0个3 link)
1 link group: 9 (1个3 link)
none link: 6

-------------------------------------------
04年:
(总122期: 2004122)
19:
NOT IN (1,2,3,4,5,6,7,8,9) 7个以10开始,4个以11开始
2 link group: 3 (0个3 link)
1 link group: 15 (1个3 link)
none link: 1
12:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 3 (1个3 link)
1 link group: 5 (0个3 link)
none link: 4
12:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 3 (1个3 link)
1 link group: 5 (1个3 link)
none link: 4

-------------------------------------------
03年:
(总89期: 2003089)
10:
NOT IN (1,2,3,4,5,6,7,8,9) 2个以10开始,2个以11开始
2 link group: 3 (1个3 link)
1 link group: 5 (0个3 link)
none link: 2
9:
NOT IN (10,11,12,13,14,15,16,17,18,19)
2 link group: 2 (0个3 link)
1 link group: 6 (0个3 link)
none link: 1
14:
NOT IN (20,21,22,23,24,25,26,27,28,29)
2 link group: 6 (3个3 link)
1 link group: 7 (1个3 link)
none link: 1
++++++++++++++++++++++++++++++++++++++++++++++++++++
select * from caihistory where num1 not in (20,21,22,23,24,25,26,27,28,29) and
num2 not in (20,21,22,23,24,25,26,27,28,29) and
num3 not in (20,21,22,23,24,25,26,27,28,29) and
num4 not in (20,21,22,23,24,25,26,27,28,29) and
num5 not in (20,21,22,23,24,25,26,27,28,29) and
num6 not in (20,21,22,23,24,25,26,27,28,29) order by 1 desc

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/14377/viewspace-1028581/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: double-color ball
下一篇: ball falling out
请登录后发表评论 登录
全部评论

注册时间:2010-09-30

  • 博文量
    191
  • 访问量
    327284