Employee

+-----------+------------+--------+

| EmployeeID| FirstName | Salary |

+-----------+------------+--------+

| 1 | John | 50000 |

| 2 | Jane | 60000 |

| 3 | Bob | 55000 |

| 4 | Alice | 70000 |

Write a SQL query to find the second-highest salary from the Employee table.

Answer:
SELECT MAX(Salary) AS SecondHighestSalary

FROM Employee

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