In this post I will explain how to get the nth highest
salary for an employee in different ways. I have below record present in my employee table.
So first is the quite straight forward query
Now second we go with the sub query so that we can find nth
salary as well.
So this query you can use to get the nth salary also, for that
you have to change the number 2 from TOP 2 salary
Now third we can get the nth highest salary using co-related
query as well.
Note: This query will not work with the duplicate salary.
Now we can use cte (common table expression) also for this.
This query will also not work with the duplicate salary. If
you want to use the CTE for duplicate salary as well then you have to use the
dense rank instead of Rank.
In the above query if you want to get the nth salary then
you can change the number 2 with any number.
Thx,
RS
