Finding nth highest salary from a table

using distinct or group by clause for similiar data ;)

Gaurav Gupta There are multiple ways to find nth highest value from a table depending upon the data present in the table. Since there is duplicate data present in the table then the below queries can be used to find the required value from the database table. Please try below solutions

Solution 1: with CTE AS( select DENSE_RANK() over (order by salary desc) as num,Salary from EmpSalary )select * from CTE where num=6