SEO

#1 (**permalink**) 02-27-2008, 01:09 PM

I would like to be able to select the maximum (highest ) value for a
field, the 2nd highest, 3rd highest, etc. Are there any other
functions that I might consider using with SQL? MAX will only pick up
the highest and MIN the lowest value, but is there a way to pick up
middle values, i.e., the 2nd, 3rd, etc, so I can list them in one row,
along with a common key?

Thanks,

Carroll Rinehart

#2 (**permalink**) 02-27-2008, 01:09 PM

Carroll wrote:
> I would like to be able to select the maximum (highest ) value for a
> field, the 2nd highest, 3rd highest, etc. Are there any other
> functions that I might consider using with SQL? MAX will only pick up
> the highest and MIN the lowest value, but is there a way to pick up
> middle values, i.e., the 2nd, 3rd, etc, so I can list them in one row,
> along with a common key?
SELECT key FROM
(SELECT ROW_NUMBER() OVER(ORDER BY key) AS rn FROM T) AS X
WHERE rn = <put your number here>

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Select MAX, 2nd highest, etc.