PMMockr

QuestionsTechnical PMTop-Interview

Write a query to find the top 3 unique salaries in each department and list all employees who have those salaries.

Focus on structuring your SQL query to first identify the top 3 unique salaries within each department. Use window functions like `ROW_NUMBER()` or `RANK()` to rank salaries, ensuring you account for ties appropriately. After determining the top salaries, join this result with the employee table to retrieve the corresponding employee details. Be prepared to explain your thought process, including how you handle potential edge cases, such as departments with fewer than three unique salaries.

What this question tests

Practise this question under interview conditions. Answer it out loud against a timer with an AI interviewer that asks follow-ups, then review the scored report.

Start a timed mock interview

Related Technical PM questions

All Technical PM questions · Product manager interview questions by skill area