美文网首页
Second Highest Salary

Second Highest Salary

作者: myang199088 | 来源:发表于2015-04-14 13:41 被阅读21次
    • Problem
      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, then the query should return null.

    • Code
      select max(Salary) from Employee where Salary < (select max(Salary) from Employee);

    相关文章

      网友评论

          本文标题:Second Highest Salary

          本文链接:https://www.haomeiwen.com/subject/knjlfttx.html