Suppose we have employee name and salary as shown in below fig.

Thank you for reading this post, don't forget to subscribe!

Query to get 3rd Highest Salary

  1. Select TOP 1 Salary as ‘3rd Highest Salary’
  2. from (SELECT DISTINCT TOP 3 Salary from Employee ORDER BY Salary DESC)
  3. a ORDER BY Salary ASC

Query to get 3rd Lowest Salary

  1. Select TOP 1 Salary as ‘3rd Lowest Salary’
  2. from (SELECT DISTINCT TOP 3 Salary from Employee ORDER BY Salary ASC)
  3. a ORDER BY Salary DESC