Second Highest Salary
来源:互联网 发布:java sleep函数 编辑:程序博客网 时间:2024/06/14 15:24
查询表中薪资第二高:
思路:
Step1 :获取不包含最高薪资的子表信息;
Step2 : 获取子表中的最高薪资
完整SQL如下:
SELECT MAX(Salary) FROM EmployeeWHERE Salary < (SELECT MAX(Salary) FROM Employee);
阅读全文
1 0
- LeetCode:Second Highest Salary
- Leetcode: Second Highest Salary
- Second Highest Salary
- Second Highest Salary
- LeetCode Second Highest Salary
- Second Highest Salary
- Second Highest Salary
- Second Highest Salary Leetcode
- Leetcode: Second Highest Salary
- Second Highest Salary
- LeetCode Second Highest Salary
- Second Highest Salary
- Second Highest Salary
- leetcode176---Second Highest Salary
- 176 - Second Highest Salary
- Second Highest Salary
- 【Leetcode】 Second Highest Salary
- leetcode-Second Highest Salary
- Educational Codeforces Round 22-C. The Tag Game-搜索,贪心
- JDBC连接数据库
- U3D -- 关于帧同步的一些文章
- CentOS 7安装部署redis
- Ted:时间管理(提炼)【有用】
- Second Highest Salary
- <开发总结>苹果ios 系统,使用自带浏览器safari,输入正确图形验证码一直报错!
- android TextView(5)-TextView一些其他常用效果
- Kotlin入门语法
- USB知识
- HR吐槽:我们都是被这些熊孩子的简历给气疯的!
- rownum between连用为什么得不到数据呢?
- Ueditor富文本编辑器报错解决方案
- std::sort排序算法