SELECT *from Employee_Test_salary go with emplsal as( SELECT Emp_Sal ,DENSE_RANK() over (order by Emp_Sal desc) as rownumber from Employee_Test_salary ) select top 1 Emp_Sal from emplsal where emplsal.rownumber =N
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)