Second Highest Salary
来源:互联网 发布:淘宝达人任务广场 编辑:程序博客网 时间:2024/05/14 11:24
select
(select distinct Salary
from Employee
order by Salary desc limit 1,1)
as SecondHighestSalary;
嵌套的select可以取代if null函数。
不加distinct, 显示SecondHighestSalary为100。为了记录去重,要加上distinct。
limit是mysql的语法
select * from table limit m,n
其中m是指记录开始的index,从0开始,表示第一条记录
n是指从第m+1条开始,取n条。
select * from tablename limit 2,4
即取出第3条至第6条,4条记录
0 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
- js规范(基于bootstrap和平时的积累)第二辑
- css规范(基于bootstrap和平时的积累)
- html规范(基于bootstrap和平时的积累)
- 2015年国内开源镜像站点汇总
- volatile,lock,synchronized
- Second Highest Salary
- 5.3.3 32位颜色
- 机器学习实战笔记之四(朴素贝叶斯)
- Java读取文件方法大全
- Vector与ArrayList区别
- Padres 之database
- 小学生管理系统V1.0
- 机房重构之--七层架构
- 编译静态二进制文件