On Mon, Apr 09, 2001 at 09:23:11AM -0400, Ronald J Kimball wrote: > SELECT term, count(*) > FROM search_terms > GROUP BY term > ORDER BY count(*) > > And the first five rows returned would contain the five most common terms. That would be ORDER BY count(*) DESC -- T.
- Most common anything in a database -- Sean Cooper
- MS Access Queries John Passaniti
- Re: MS Access Queries Brett W. McCoy
- Re: Most common anything in a database -- Ronald J Kimball
- Tommy Wareing
