Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996

Using GROUP BY Clause

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 table
GROUP 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.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date