177. Nth Highest Salary
来源:互联网 发布:mysql持久化 编辑:程序博客网 时间:2024/06/05 10:36
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 wheren = 2 is 200
. If there is no nth highest salary, then the query should returnnull
.
Subscribe to see which companies asked this question.
MySQL:
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
- 177. Nth Highest Salary
- leetcode 177. Nth Highest Salary
- leetcode.177. Nth Highest Salary
- leetcode 177. Nth Highest Salary
- Leetcode 177. Nth Highest Salary
- leetcode-database-177. Nth Highest Salary
- leetcode SQL题目 177. Nth Highest Salary
- 【leetcode Database】177. Nth Highest Salary
- LeetCode Nth Highest Salary
- Nth Highest Salary
- Nth Highest Salary
- 177 - Nth Highest Salary
- Nth Highest Salary
- Nth Highest Salary
- MySQL-Nth Highest Salary
- Leetcode177. Nth Highest Salary
- 【LeetCode】Second Highest Salary && Nth Highest Salary
- LeetCode | Second Highest Salary & Nth highest salary
- Spark 基础学习笔记
- 汇编笔记3
- MKL学习——矩阵向量操作
- Mongdb3.2.4(64bit) 数据库导入导出字段修改等操作
- 简明机器学习教程——实践篇(一):从感知机入手
- 177. Nth Highest Salary
- 原型模式 C#
- python 面试题
- HTML初学笔记2
- Ubuntu下python网络爬虫及机器学习环境安装
- SharedPreferences
- AC自动机专题——K
- OpenCV+Java开发环境配置
- 虎小五进阶之路——@MappedSuperclass注解的使用