第二高工资(Second Higest Salary)
来源:互联网 发布:特朗普 社交软件 编辑:程序博客网 时间:2024/04/29 05:47
从一张Employee的表中选出第二稿工资的人。
表结构如图所示:
SQL语句如下:
select IFNULL((select e.Salary from Employee e group by e.Salary oyder by e.Salary desc limit 1,1),null);
解释如下:
对工资进行降序分组排序,limit 1,1的意思是选择第二条记录。
0 0
- 第二高工资(Second Higest Salary)
- LeetCode database 之 Second Highest Salary(第二高薪水)
- Nth Highest Salary --- 找出第N高的工资
- 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
- linux下USB驱动
- 机房收费系统之测试计划
- 蓝桥杯-数列特征(basic)
- Solr基础教程之Query(四)
- 操作符
- 第二高工资(Second Higest Salary)
- 利用可变参实现fprintf函数
- Android中使EditText失去焦点,edittext禁止弹出键盘
- OpenJudge百炼习题解答(C++)--题4085:数组去重排序
- GDKOI2016总结
- 查看网卡流量
- HDU - 3635 Dragon Balls
- JNI Study Notes
- POJ3159 最大差距(差分约束系统)