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

Question

i want details of 2nd record details of employee

Upendra Pratap Shahi · Answer

SELECT Name FROM Employees WHERE Salary = (SELECT MIN(Salary) FROM (SELECT DISTINCT TOP (2) Salary FROM Employees ORDER BY Salary DESC) T);

Pankaj Kumar Choudhary · Answer

Hello Ravi you can use this query select top 2 from (select * from Table_Name order by salary DESC)tmp

Ramesh Maruthi · Answer

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

Srikanth Reddy · Answer

To retrieve based on your count use Row_Number()

Srikanth Reddy · Answer

select * from emp where id=2