[Taha Okla]

وعليكم السلام ورحمة الله وبركاته :

كود :

select * from Emp_Salary where Emp_Salary.Salary =( select min(salary) from (select Top(3) * from Emp_Salary order by Emp_Salary.Salary DESC) as empMinSalary);

---

كود :

select top(1) * from (select Top(3) * from Emp_Salary order by Emp_Salary.Salary DESC ) As empMinSalary Order by empMinSalary.Salary