176. Second Highest Salary
来源:互联网 发布:mac版的rar 解压软件 编辑:程序博客网 时间:2024/06/05 15:26
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 returnnull
.
+---------------------+| SecondHighestSalary |+---------------------+| 200 |+---------------------+ code:# Write your MySQL query statement belowselect distinct Salary as SecondHighestSalary from Employee order by Salary desc limit 1 offset 1
阅读全文
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
- ABB开发学习笔记
- Colossal Fibonacci Numbers! UVA
- ccf刷题记02
- 栈
- HashMap,Hashtable,ConcurrentHashMap 和 synchronized Map 的原理和区别
- 176. Second Highest Salary
- Android 设计模式之观察者模式
- 2.2.9同一个类的不同静态方法不同实例不同线程是同步的
- 疫苗:JAVA HASHMAP的死循环
- linux命令详解(cp命令)
- CodeForces 158E Phone Talks dp
- Python基础笔记
- HDFS上数据保存到Hbase运行报错:NoClassDefFoundError: org/apache/hadoop/hbase/HBaseConfiguration
- hash算法以及解决冲突的方法