Second Highest Without Aggregates

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Second Highest Without Aggregates. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

AvidXchange wants to review compensation bands by department. Write a PostgreSQL query to find the second highest distinct salary in each department, without using any aggregate functions such as MAX() or COUNT().

Requirements

Return one row per department that has at least two distinct salaries.
Find the second highest distinct salary within each department.
Do not use aggregate functions in the solution.
Sort the final result by department_name.

Schema

employees

Column	Type	Description
employee_idPK	INT	Primary key for the employee
employee_name	VARCHAR(100)	Employee name
department_name	VARCHAR(100)	Department name
salary	INT	Employee salary, may repeat across employees
hire_date	DATE	Employee hire date

Tablesemployees

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results