What is the SQL query to get the third highest salary of an employee from employee table

Question

Hi!!

Can someone tell me how to write a SQL query to get the third highest salary of an employee from employee_table?

Comments

try this

SELECT TOP 3 salary

FROM(

SELECT TOP 1 salary

FROM Employee_Table

ORDER BY salary DESC) AS emp

ORDER BY salary ASC;

Answer 1

You can try out something like this:

SELECT TOP 1 salary

FROM(

SELECT TOP 3 salary

FROM employee_table

ORDER BY salary DESC) AS emp

ORDER BY salary ASC;

Comments

This is correct

SELECT TOP 3 salary

FROM(

SELECT TOP 1 salary

FROM Employee_Table

ORDER BY salary DESC) AS emp

ORDER BY salary ASC;