177. Nth Highest Salary

末蓝、 2022-04-24 14:58 251阅读 0赞

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.
    
    +------------------------+
    | getNthHighestSalary(2) |
    +------------------------+
    | 200                    |
    +------------------------+

此题与[上一题][Link 1]大同小异。代码如下：

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
    BEGIN
      DECLARE M INT;
      SET M=N-1;
      RETURN (
          # Write your MySQL query statement below.
          Select
            (Select Distinct Salary
            From Employee
            Order By Salary Desc
            Limit 1 Offset M) AS N_th_HighestSalary
      );
    END

[Link 1]: https://blog.csdn.net/weixin_41704428/article/details/89639720

发表评论取消回复

表情：

评论列表（有 0 条评论，251人围观）

还没有评论，来说两句吧...

相关阅读

相关【leetcode Database】177. Nth Highest Salary

题目： Write a SQL query to get the nth highest salary from the `Employee` table. +--

本是古典何须时尚/ 2022年09月25日 01:24/ 0 赞/ 272 阅读

相关【leetcode Database】184. Department Highest Salary

题目： The `Employee` table holds all employees. Every employee has an Id, a salary, and t

末蓝、/ 2022年09月25日 00:22/ 0 赞/ 27 阅读

相关【leetcode Database】176. Second Highest Salary

题目： Write a SQL query to get the second highest salary from the `Employee` table.

叁歲伎倆/ 2022年09月24日 06:25/ 0 赞/ 228 阅读

相关 [LeetCode][Database]Nth Hightest Salary

题目来源：[https://leetcode.com/problems/nth-highest-salary/][https_leetcode.com_problems_nth

淩亂°似流年/ 2022年08月07日 12:56/ 0 赞/ 22 阅读

相关 [LeetCode][Database]Department Highest Salary

题目来源：[https://leetcode.com/problems/department-highest-salary/][https_leetcode.com_probl

灰太狼/ 2022年08月07日 12:56/ 0 赞/ 262 阅读

相关 [LeetCode][Database]Second Highest Salary

题目来源：[https://leetcode.com/problems/second-highest-salary/][https_leetcode.com_problems_

刺骨的言语ヽ痛彻心扉/ 2022年08月07日 12:54/ 0 赞/ 150 阅读

相关 leetcode 177. Nth Highest Salary

177. Nth Highest Salary Question Editorial Solution [My Submissions][] Total Acc

Myth丶恋晨/ 2022年07月19日 01:55/ 0 赞/ 253 阅读

相关 leetcode 176. Second Highest Salary

176. Second Highest Salary Question Editorial Solution [My Submissions][] Total

比眉伴天荒/ 2022年07月19日 01:53/ 0 赞/ 257 阅读

相关 177. Nth Highest Salary

Write a SQL query to get the nth highest salary from the Employee table. +-

末蓝、/ 2022年04月24日 14:58/ 0 赞/ 252 阅读

相关 176. Second Highest Salary

Write a SQL query to get the second highest salary from the Employee table.

r囧r小猫/ 2022年02月13日 19:36/ 0 赞/ 278 阅读