Just for fun Lotto SQL

Last Post 29 Jan 2007 09:42 PM by SwePeso. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
scripter
New Member
New Member

--
02 Dec 2006 08:37 PM
The data table looks like this

date num1 num2 num3 num4 num5 num6
1/1/06 1 45 32 21 15 48

SQL script 1 should be able to do the following
show the Top 3 number pairs
another words if the pair 45 and 15 shows up 98 times and 32 and 12 shows up 3 times

then I want to have 45 and 15 show as one of the top 3 number pairs

I know this is a difficult one


So that being said see if I can re-explain it here
I have say two dates
1/1/2006 and 1/2/2006
on the first date I have six numbers being
1,24,45,35,47,14
and the second date I have
24,35,9,15,46,17

Now I can if it is needed to re do the data structure to reflect it like this
date num
1/1/2006 1
1/1/2006 24
1/1/2006 45
1/1/2006 35
1/1/2006 47
1/1/2006 14

1/2/2006 24
1/2/2006 35
1/2/2006 9
1/2/2006 15
1/2/2006 46
1/2/2006 17



Now somehow I am not sure how but I need to take the six numbers from each date and compare them with every other date.

so another words from date one take 1 and 24 and see if that combo matches other dates then go to 1 and 45 and do the same and so on.
SwePeso
New Member
New Member

--
29 Jan 2007 09:42 PM
You are not authorized to post a reply.

Acceptable Use Policy