'n'th Maximum value of a column.

Summary:

To get the 'n'th Maximum value of a column.

'n'th Maximum value of a column.

atchaya 27 Dec 2009 01:56

What is the possible ways to get the 'n'th Maximum value of a column?

Re: 'n'th Maximum value of a column.

atchaya 27 Dec 2009 01:57

SELECT MIN(columnname)
FROM ( SELECT coumnname FROM tablename ORDER BY columnname DESC)
WHERE rownum <= n