kiritsinh parmar kiritsinh parmar - 24 days ago 6
SQL Question

Query to find nth max value of a column

I want to find 2nd,3rd..nth maximum value of a column

TK. TK.
Answer Source

You could sort the column into descending format and then just obtain the value from the nth row.

EDIT::

Updated as per comment request. WARNING completely untested!

SELECT DOB FROM (SELECT DOB FROM USERS ORDER BY DOB DESC) WHERE ROWID = 6

Something like the above should work for Oracle ... you might have to get the syntax right first!