Title 2:mysql----------Second Highest Salary

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

+----+--------+| Id | Salary |+----+--------+| 1 | |    | 2 | | |    3  |    |+----+--------+

For example, given the above Employee table, the second highest salary is 200 . If there is no second highest salary and then the query should return null .

Title Answer:

# Write your MySQL query statement belowselect Max (Salary) from Employee WHERE Salary < (SELECT max (Salary) from employ Ee

Topic Analysis:

Select Max (Salary) from the employee WHERE Salary < (select Max (Salary) from employee)

Using Max () would return a NULL if the value doesn ' t exist. So there are no need to UNION a NULL. Of course, if the second highest value is guaranteed to exist, the using LIMIT, the "the best answer."

Title 2:mysql----------Second Highest Salary