Nth Highest salary-Oracle

above will give nth max salary info

2. using rank function

since there is a duplicate at 4, it ommits next rank 5,goes to 6. if we need 5th ,then we can use densk_rank

3,