select most common value
- From: Leo <Leo@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Jun 2005 02:24:06 -0700
I am trying to create a list of the top 5 values in a column where I can
select which top value I want. For example with values
1,1,2,3,3,3
I can select the 2nd most common value (which is 1).
.
- Follow-Ups:
- Re: select most common value
- From: David Portas
- Re: select most common value
- Prev by Date: Re: SQL and Grouping
- Next by Date: Re: select most common value
- Previous by thread: Help with Query
- Next by thread: Re: select most common value
- Index(es):
