[LeetCode][Database]Second Highest Salary
来源:互联网 发布:如何制作视频短片软件 编辑:程序博客网 时间:2024/05/05 05:11
题目来源:https://leetcode.com/problems/second-highest-salary/
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.
即:从给出的工资表中,输出第二高的工资,若没有第二高的(指的是去重后的第二高)则返回null。
意思是低于最高工资的剩下id中的最高工资,所以有:
select max(Salary) from Employee
where Salary < (select max(Salary) from Employee)
难得一次通过了
0 0
- [LeetCode][Database]Second Highest Salary
- 【leetcode】database Second Highest Salary
- Database LeetCode Second Highest Salary
- [Leetcode] [Database] Second Highest Salary解题
- 【leetcode Database】176. Second Highest Salary
- LeetCode Database #176 Second Highest Salary
- LeetCode:Second Highest Salary
- Leetcode: Second Highest Salary
- LeetCode Second Highest Salary
- Second Highest Salary Leetcode
- Leetcode: Second Highest Salary
- LeetCode Second Highest Salary
- 【Leetcode】 Second Highest Salary
- leetcode-Second Highest Salary
- 【LeetCode】Second Highest Salary && Nth Highest Salary
- LeetCode | Second Highest Salary & Nth highest salary
- LeetCode database 之 Second Highest Salary(第二高薪水)
- 【leetcode SQL】Second Highest Salary
- JavaScript规范
- 当你无聊时可以做这15件高效的事
- 黑马程序员-Java集合框架Set
- 数据库调优教程(二)慢查询数据准备
- 读写锁ReentrantReadWriteLock
- [LeetCode][Database]Second Highest Salary
- git使用ssh免登录(git服务器为bitbucket.org)
- 学习日记java 线程的停止,jion,yield
- Leetcode---Construct Binary Tree from Inorder and Postorder Traversal
- vitualbox增加磁盘容量
- 黑马程序员——面向对象(二)
- android 借助bmob api实现app支付宝和微信收款
- Linux删除除了某个文件之外的所有文件
- Android-读取文件数据