best query for find the 3rd highest salary?

Question

Marimuthu Arigovindasamy · Answer

try the below one. select top 1 salary from ( select top 3 salary from employee order by salary desc ) EmployeeDetails order by salary asc

Marimuthu Arigovindasamy · Answer

Have u solved the pbm?