how to write a query select top 2 record salary in employee

SELECT Name

FROM Employees

WHERE Salary = (SELECT MIN(Salary)

FROM (SELECT DISTINCT TOP (2) Salary

FROM Employees

ORDER BY Salary DESC) T);

0

Hello Ravi you can use this query

select top 2 from

(select * from Table_Name order by salary DESC)tmp

0

Hi Ravi,

SELECT * FROM ( SELECT e.*, row_number()
OVER (ORDER BY sal DESC) rn FROM emp e )
WHERE rn = 2;

0

To retrieve based on your count use Row_Number()

0

select * from emp where id=2

0