Question 17:How to get the 'n' th maximum value of a column? September 28, 2009 We can get the nth maximum value through query by using the combination of order by clause and rownum pseudo column. The Query following. SELECT MIN(columnname) FROM ( SELECT coumnname FROM tablename ORDER BY columnname DESC) WHERE rownum Read more