Second highest salary using subquery

SQL Medium 3 views
Back to Questions
Previous Find latest order per customer using subquery Medium P Next Find customers with more than N orders Medium N

Problem Description

Return the second highest distinct salary from Employees.

Input Format

SQL query

Output Format

Result set

Sample Test Case

Input:
Employees(salary)
Output:
One row

Constraints

Use subquery with DISTINCT
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next