Question:
I am writing a Lottery Simulator, I have a database which contains seven fields, each field of each record contains a number from 1 to 49. I am looking for help writing the code that will scan each record in the database and return the six numbers that show up most frequently.
Answer:
You will have to do each field individually, or you can combine the results. Here is a SQL statement that will get you the count of the number of each row shown in the database for a particular column:
SELECT field1, count(field1) FROM tableGROUP BY field1
That will get you a view of the numbers in the database, along with the number of times they appear in the database. You’ll have to do that statement for each column (field1 – field6) and then combine the results.