Welcome Guest
Log In | Register )
You last visited May 28, 2017, 6:18 am
All times shown are
Eastern Time (GMT-5:00)

# Looking for one number for SQL query. See example below:

Topic closed. 1 reply. Last post 3 years ago by Igamble.

 Page 1 of 1
PrintE-mailLink
Thread Starter
Milwaukee, Wisconsin
United States
Member #157451
July 19, 2014
1101 Posts
Offline
 Posted: September 7, 2014, 11:40 pm - IP Logged

Can anyone predict one key number for the 9/8/14 Pick 3 drawing?

Example:

Let's say that you have a very strong hunch that one of the numbers for tomorrow's Pick 3 drawing is 4.

If the number 4 is in a combination whose sum is not equal to the last eight sums, then one of the following combinations will occur:

 kEY = 4 FROM ALL COMBINATIONS  AND SUM <> LAST 8 SUMS x y z SUM COMBO 4 9 9 22 499 4 8 9 21 489 4 8 8 20 488 4 7 9 20 479 4 7 8 19 478 4 6 9 19 469 4 7 7 18 477 4 6 8 18 468 4 5 9 18 459 4 6 6 16 466 4 5 7 16 457 4 4 8 16 448 3 4 9 16 349 4 4 5 13 445 3 4 6 13 346 2 4 7 13 247 1 4 8 13 148 0 4 9 13 049 3 4 4 11 344 2 4 5 11 245 1 4 6 11 146 0 4 7 11 047 3 3 4 10 334 2 4 4 10 244 1 4 5 10 145 0 4 6 10 046 1 2 4 7 124 0 3 4 7 034 1 1 4 6 114 0 2 4 6 024 0 0 4 4 004 N = 31

If any of the above combinations have already been selected in 2014, the result would be:

 kEY = 4 FROM ALL COMBINATIONS  AND SUM <> LAST 8 SUMS AND COMBINATION HAS BEEN SELECTED IN 2014 x y z Sum COMBO 4 8 9 21 489 4 7 8 19 478 4 5 9 18 459 4 6 8 18 468 4 7 7 18 477 3 4 9 16 349 4 4 8 16 448 4 5 7 16 457 4 6 6 16 466 0 4 9 13 049 1 4 8 13 148 3 4 6 13 346 0 4 7 11 047 1 4 6 11 146 0 4 6 10 046 1 4 5 10 145 3 3 4 10 334 1 2 4 7 124 0 2 4 6 024 1 1 4 6 114 0 0 4 4 004 N = 21

I'm new to this forum. If this type of post is inappropriate for the Wisconsin Pick 3 forum, please let me know.

Thanks

nj
United States
Member #145657
August 10, 2013
1013 Posts
Offline
 Posted: September 8, 2014, 12:16 am - IP Logged

Can anyone predict one key number for the 9/8/14 Pick 3 drawing?

Example:

Let's say that you have a very strong hunch that one of the numbers for tomorrow's Pick 3 drawing is 4.

If the number 4 is in a combination whose sum is not equal to the last eight sums, then one of the following combinations will occur:

 kEY = 4 FROM ALL COMBINATIONS  AND SUM <> LAST 8 SUMS x y z SUM COMBO 4 9 9 22 499 4 8 9 21 489 4 8 8 20 488 4 7 9 20 479 4 7 8 19 478 4 6 9 19 469 4 7 7 18 477 4 6 8 18 468 4 5 9 18 459 4 6 6 16 466 4 5 7 16 457 4 4 8 16 448 3 4 9 16 349 4 4 5 13 445 3 4 6 13 346 2 4 7 13 247 1 4 8 13 148 0 4 9 13 049 3 4 4 11 344 2 4 5 11 245 1 4 6 11 146 0 4 7 11 047 3 3 4 10 334 2 4 4 10 244 1 4 5 10 145 0 4 6 10 046 1 2 4 7 124 0 3 4 7 034 1 1 4 6 114 0 2 4 6 024 0 0 4 4 004 N = 31

If any of the above combinations have already been selected in 2014, the result would be:

 kEY = 4 FROM ALL COMBINATIONS  AND SUM <> LAST 8 SUMS AND COMBINATION HAS BEEN SELECTED IN 2014 x y z Sum COMBO 4 8 9 21 489 4 7 8 19 478 4 5 9 18 459 4 6 8 18 468 4 7 7 18 477 3 4 9 16 349 4 4 8 16 448 4 5 7 16 457 4 6 6 16 466 0 4 9 13 049 1 4 8 13 148 3 4 6 13 346 0 4 7 11 047 1 4 6 11 146 0 4 6 10 046 1 4 5 10 145 3 3 4 10 334 1 2 4 7 124 0 2 4 6 024 1 1 4 6 114 0 0 4 4 004 N = 21

I'm new to this forum. If this type of post is inappropriate for the Wisconsin Pick 3 forum, please let me know.

Thanks

WELCOME TO LP SQL MAN !is your  only 3rd post and you look like a winner already…great work !

IT WOULD LOOK BETTER IF IS POSTED IN LOTTERY SYSTEMS FORUM -IT GETS MORE VIEWS OR IN THE MATHEMATICS FORUM.SORRY FOR SPELLING ERRORS..OK ENJOY

ps-i may need you to program something in the future …i will send pm

 Page 1 of 1