It will be work in sql server. select * from (select ROW_NUMBER() over(order by salary) as rownumber,Id,Dept,salary from Employee) as Employee where rownumber=2