← Amazon questions
CodingReported in a candidate post, Dec 2024

Department top three salaries and RANK vs DENSE_RANK

Filed under Amazon

Given Employee(id, name, salary, departmentId) and Department(id, name), write a SQL query that returns, for each department, the employees whose salary is among the top three distinct salaries in…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Amazon questions

Collected from public candidate posts and coding forums. Updated Nov 2026.