Employee Runner-Up Salary Lookup

MEDIUM20 pts

Your team is building a compensation analytics endpoint over an Employee table with columns (id, salary).

You must return the second-highest distinct salary in the dataset. The output must be a one-column result named SecondHighestSalary.

Important rules:

Submissions are supported in:

Example

Input

Employee:
| id | salary |
|----|--------|
| 1  | 100    |
| 2  | 200    |
| 3  | 300    |

Output

[{"SecondHighestSalary":200}]

Explanation

Distinct salaries are [300, 200, 100], so the second-highest value is 200.

Example

Input

Employee:
| id | salary |
|----|--------|
| 1  | 500    |
| 2  | 500    |

Output

[{"SecondHighestSalary":null}]

Explanation

There is only one distinct salary value, so no second-highest value exists.

Example

Input

Employee:
| id | salary |
|----|--------|
| 1  | -10    |
| 2  | -30    |
| 3  | -10    |
| 4  | -20    |

Output

[{"SecondHighestSalary":-20}]

Explanation

Distinct salaries are [-10, -20, -30] in descending order. The second value is -20.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in Employee <= 100,000
Employee.id is unique
salary is a signed integer in the range [-2,147,483,648, 2,147,483,647]
Output must contain exactly one column: SecondHighestSalary
Use SQLite 3.27.2 behavior for SQL submissions
For Pandas, return a DataFrame with one row and one column named SecondHighestSalary

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

employee =

[{"id":1,"salary":100},{"id":2,"salary":200},{"id":3,"salary":300}]

Loading problem...