Write an SQL query to find the second highest salary from the Employee table. If there is no second highest salary, the query should return null.

SQL query to retrieve the second highest salary from the Employee table.

• Use the DISTINCT keyword to avoid duplicate salaries.

• Order the salaries in descending order and limit the results.

• Use a subquery...read more

SELECT MAX(SALARY)

FROM Employee

WHERE SALARY < (SELECT MAX(SALARY) FROM Employee);

Select * from (select name,salary, dense_rank over (order by salary desc) as rank from employees) where rank=2;

SELECT MAX (SALARY)

FROM TABLE_NAME

WHERE SALARY < (SELECT MAX (SALARY) FROM TABLE_NAME);