176. Second Highest Salary
来源:互联网 发布:js定时器重复执行 编辑:程序博客网 时间:2024/05/16 09:46
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 query should return 200 as the second highest salary. If there is no second highest salary, then the query should return null.
+———————+
| SecondHighestSalary |
+———————+
| 200 |
+———————+
# Write your MySQL query statement belowSelect MAX(Salary) as SecondHighestSalary from Employeewhere Salary < (Select MAX(Salary) from Employee)
阅读全文
0 0
- 176. Second Highest Salary
- 176. Second Highest Salary
- 176. Second Highest Salary
- 176. Second Highest Salary
- 176. Second Highest Salary
- 176. Second Highest Salary
- 176. Second Highest Salary
- leetcode 176. Second Highest Salary
- leetcode 176. Second Highest Salary
- leetcode.176. Second Highest Salary
- leetcode 176. Second Highest Salary
- Leetcode 176. Second Highest Salary
- 176. Second Highest Salary#1
- leetcode 176. Second Highest Salary
- leetcode 176. Second Highest Salary
- 176. Second Highest Salary(Leetcode)
- [理解leetcode解法]176. Second Highest Salary
- 【leetcode Database】176. Second Highest Salary
- [JAVA]重写父类方法并向上转型时的初始化问题
- Maximum_Subarray
- 关于IP选项
- python
- 设计模式学习之生成器模式与实例
- 176. Second Highest Salary
- LintCode 67.二叉树的中序遍历
- mybatis一对多关系 collection的使用
- 东方财富研发岗位笔试题
- 使用命令行工具编译C#程序
- spring学习笔记十六 重用切点表达式
- spring mybatis 搭建环境
- hdu2176取(m堆)石子游戏 ——Nim 博弈
- Android Framework