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
Objective type Questions with Answers and Explanations for Oracle PL/SQL and Database.