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.

Reply via email to