g0101_0200.s0177_nth_highest_salary.readme.md Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of leetcode-in-java Show documentation
Show all versions of leetcode-in-java Show documentation
Java-based LeetCode algorithm problem solutions, regularly updated
177\. Nth Highest Salary
Medium
SQL Schema
Table: `Employee`
+-------------+------+
| Column Name | Type |
+-------------+------+
| id | int |
| salary | int |
+-------------+------+
id is the primary key column for this table. Each row of this table contains information about the salary of an employee.
Write an SQL query to report the `nth` highest salary from the `Employee` table. If there is no `nth` highest salary, the query should report `null`.
The query result format is in the following example.
**Example 1:**
**Input:**
Employee table:
+----+--------+
| id | salary |
+----+--------+
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
+----+--------+
n = 2
**Output:**
+------------------------+
| getNthHighestSalary(2) |
+------------------------+
| 200 |
+------------------------+
**Example 2:**
**Input:**
Employee table:
+----+--------+
| id | salary |
+----+--------+
| 1 | 100 |
+----+--------+
n = 2
**Output:**
+------------------------+
| getNthHighestSalary(2) |
+------------------------+
| null |
+------------------------+