Record count - Entered the most times - AndreaVB Visual Basic and VB.NET source code discussion board

Next Topic (How to add a column to an SQL database)

AndreaVB Forum : Database : Record count - Entered the most times

Poster

Message

mhpate
Level: Trainee

Registered: 21-04-2007
Posts: 3

Record count - Entered the most times

Is therw away I can find out which number has been entered the most?
I have a field that will have numbers from 1 - 44
I need to find wich number has been entered the
greatest number of times
the second and third.
fld name Mb.

23-04-2007 at 12:28 PM

vbgen
Level: Moderator

Registered: 10-10-2002
Posts: 876

Re: Record count - Entered the most times

SELECT field, COUNT(*)
FROM table
GROUP BY field
HAVING COUNT(*) >= ALL
(SELECT COUNT(*)
FROM table
GROUP BY field)

uhmm.. it won't answer your entire question, but can you try and start with that?

____________________________
Been busy trying to take a second degree <--it's not working out...

23-04-2007 at 01:36 PM

AndreaVB Forum : Database : Record count - Entered the most times


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincani