Interview Question | How to find 2nd max salary in a table using analytical functions in oracle
This video is useful to find the nth max salary from a table. It shows all the different ways and possibilities to find the nth max salary from a table, using a rownum sub query and the later on using a dense rank function.