Welcome Guest
Log In | Register )
You last visited December 6, 2016, 12:39 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 2 years ago by Igamble.

Page 1 of 1
51
PrintE-mailLink
SQL-MAN's avatar - SQL Avatar.gif
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

xyzSUMCOMBO
49922499
48921489
48820488
47920479
47819478
46919469
47718477
46818468
45918459
46616466
45716457
44816448
34916349
44513445
34613346
24713247
14813148
04913049
34411344
24511245
14611146
04711047
33410334
24410244
14510145
04610046
1247124
0347034
1146114
0246024
0044004
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

xyzSumCOMBO
48921489
47819478
45918459
46818468
47718477
34916349
44816448
45716457
46616466
04913049
14813148
34613346
04711047
14611146
04610046
14510145
33410334
1247124
0246024
1146114
0044004
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

    Igamble's avatar - spider
    nj
    United States
    Member #145657
    August 10, 2013
    974 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

    xyzSUMCOMBO
    49922499
    48921489
    48820488
    47920479
    47819478
    46919469
    47718477
    46818468
    45918459
    46616466
    45716457
    44816448
    34916349
    44513445
    34613346
    24713247
    14813148
    04913049
    34411344
    24511245
    14611146
    04711047
    33410334
    24410244
    14510145
    04610046
    1247124
    0347034
    1146114
    0246024
    0044004
    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

    xyzSumCOMBO
    48921489
    47819478
    45918459
    46818468
    47718477
    34916349
    44816448
    45716457
    46616466
    04913049
    14813148
    34613346
    04711047
    14611146
    04610046
    14510145
    33410334
    1247124
    0246024
    1146114
    0044004
    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