Second Highest Salary

  Write A SQL query to get the second highest salary from the Employee table. +----+--------+    | Id |    Salary | +----+--------+    | 1 |    100 | | 2 |    200 | | 3 |    300 | +----+--------+ 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. Solution One: # Write your MySQL query statement below Select (select Salary from the Employee group by salary order by salary desc limit) as ' secondhighestsalary '; solution two: Sele CT Max (Salary) from the employee where salary < (select Max (Salary) from employee) Essentials: 1, de-weight, so use Group B    Y grouping 2, because to get the second big salary, so need to sort, 3, Max to get the maximum, but to get the second maximum, so you want to use limit 0,1,2,3 limit Start,len start for the number of pages, ... Len represents the number of records in the page 4, because the column name of the answer is Secondhighestsalary, so the last to use as to rename 5, two Select is required, the second select is used to rebuild the column and column values. Because second highest salary if it does not exist, then the internal select return value is null and does not meet the answer. Therefore, you need to rebuild the column and column values for the internal select. 

Second Highest Salary