How should I practice Top Salaries By Department?

Start by reading the full statement, solve the visible examples, then compare the pattern against related ZS onsite interview problems in FastPrep.

Is Top Salaries By Department associated with ZS?

FastPrep tags this as a ZS onsite interview coding practice problem when the problem catalog has that company and stage context.

Problem · Database

Top Salaries By Department

● Easy

ZSNEW GRADONSITE INTERVIEW

Problem statement

The table employees stores one row per employee, including that employee's department and salary.

For each department, find the highest salary. Return every employee who earns that department-highest salary, including all employees tied at the top.

Return department_id, employee_id, employee_name, and salary. Order rows by department_id ascending, then employee_id ascending.

What the interview report shared

The interviewer asked SQL to find the top salaries by department.

employees
Column	Meaning
`employee_id`	Unique employee identifier
`employee_name`	Employee display name
`department_id`	Department identifier
`salary`	Employee salary

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

employees

One row per employee.

Column	Type	Nullable	Description
employee_idPK	Integer	No	—
employee_name	Text	No	—
department_id	Integer	No	—
salary	Integer	No	—

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
department_id	Integer	No	—
employee_id	Integer	No	—
employee_name	Text	No	—
salary	Integer	No	—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

The employees table has between 1 and 10^5 rows.
employee_id is unique and non-null.
employee_name, department_id, and salary are non-null.
0 <= salary <= 10^9.