SQL Highest Salary | Dataford Interview Questions

Finastra is reviewing compensation data for employees supporting products such as Fusion. Write a PostgreSQL query that returns the single employee with the highest recorded salary.

Requirements

Return the employee's ID, name, department, and salary.
Sort salaries from highest to lowest and return exactly one employee. Ignore rows where salary is NULL.
If multiple employees share the highest salary, select the employee with the lowest employee_id for deterministic output.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Employee's department
salary	NUMERIC(12,2)	Annual salary, which may be unavailable

Your question is SQL Highest Salary. 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

Finastra is reviewing compensation data for employees supporting products such as Fusion. Write a PostgreSQL query that returns the single employee with the highest recorded salary.

Requirements

Return the employee's ID, name, department, and salary.
Sort salaries from highest to lowest and return exactly one employee. Ignore rows where salary is NULL.
If multiple employees share the highest salary, select the employee with the lowest employee_id for deterministic output.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Employee's department
salary	NUMERIC(12,2)	Annual salary, which may be unavailable

Your question is SQL Highest Salary. 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.