SQL Query for Top Salaries | Dataford Interview Questions

The Allscripts people operations team wants to identify employees with the highest recorded salary. Write a PostgreSQL query using the employees table to return all employees tied for the highest salary.

Requirements

Group employees by salary and return the highest salary.
Combine the names of every employee at that salary into one comma-separated list, sorted alphabetically.
Ignore employees whose salary is NULL and return exactly one result row.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Allscripts department
salary	NUMERIC(10,2)	Annual salary in USD

Your question is SQL Query for Top Salaries. Start with the requirements and the one table in the Question tab.

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

Problem

Requirements

Group employees by salary and return the highest salary.
Combine the names of every employee at that salary into one comma-separated list, sorted alphabetically.
Ignore employees whose salary is NULL and return exactly one result row.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Allscripts department
salary	NUMERIC(10,2)	Annual salary in USD

Your question is SQL Query for Top Salaries. Start with the requirements and the one table in the Question tab.

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