leetcode.177. Nth Highest Salary
来源:互联网 发布:ubuntu怎么连接wifi 编辑:程序博客网 时间:2024/05/16 05:13
Write a SQL query to get the nth highest salary from the Employee
table.
+----+--------+| Id | Salary |+----+--------+| 1 | 100 || 2 | 200 || 3 | 300 |+----+--------+
For example, given the above Employee table, the nth highest salary where n = 2 is 200
. If there is no nth highest salary, then the query should return null
.
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGIN declare M INT; SET M = N -1; RETURN ( # Write your MySQL query statement below. select distinct Salary from Employee order by Salary desc limit M,1 );END
0 0
- leetcode 177. Nth Highest Salary
- leetcode.177. Nth Highest Salary
- leetcode 177. Nth Highest Salary
- Leetcode 177. Nth Highest Salary
- LeetCode Nth Highest Salary
- 【LeetCode】Second Highest Salary && Nth Highest Salary
- LeetCode | Second Highest Salary & Nth highest salary
- leetcode-database-177. Nth Highest Salary
- leetcode SQL题目 177. Nth Highest Salary
- 【leetcode Database】177. Nth Highest Salary
- 177. Nth Highest Salary
- leetcode 177 Nth Highest Salary
- [LeetCode]Nth Highest Salary,解题报告
- Nth Highest Salary
- Nth Highest Salary
- 177 - Nth Highest Salary
- Nth Highest Salary
- Nth Highest Salary
- MAP
- java开发中JDBC连接数据库
- Hibernate+JPA注解
- 字符串-401 - Palindromes
- 如何根据基类指针来判断这个基类是由那个子类转换而来!
- leetcode.177. Nth Highest Salary
- ZBrush中保存历史记录太多该如何解决
- HTML5
- oninput,onpropertychange,onchange的用法
- android studio Git版本管理工具的使用
- Java ConcurrentModificationException异常原因和解决方法
- web,视频播放两种方法
- 关于语义化标签
- [BZOJ4551][JZOJ4604]【TJOI&HEOI2016】D1T1 树