Interview Query

Largest Salary by Department

Start Timer

0:00:00

Upvote
20
Downvote
Save question
Mark as completed
View comments (29)
Next question

Given a table called employees, get the largest salary of any employee by department

Example:

Input:

employees table

Column Type
id INTEGER
department VARCHAR
salary INTEGER

Output:

Column Type
department VARCHAR
largest_salary INTEGER
.
.
.
.
.


Comments

Loading comments