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.

To find the second highest salary in an employee table using SQL, we can use various methods like subqueries or the DISTINCT clause.

• Use a subquery: SELECT MAX(Salary) FROM Employee WHERE Salary < (SEL...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);