Question

Write a sql query to get the third highest salary of an employee from employee_table?

Answer 1

Answer:

select top 1 * from ( select top 3* from emp) order by salary;

Explanation:

The inner query will fetch the first three rows of the table, and then the outer query will give u the third highest salary from it. When you use order by, it sorts in ascending order by default.