# SQL interview question: top three unique salaries by department

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/5087/sql-top-three-salaries-per-department
Source observed: 2026-11-04T21:34:40.293Z
Last checked: 2026-11-04T21:34:40.293+00:00
Indexed: 2026-11-05T02:50:45.856+00:00

---

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

We publish this as an Aced (formerly Exponent) interview-practice question for **Data Engineer** candidates. It is categorized as **Coding** and **SQL**, and is associated with **Amazon**. The interview record indicates **1 interview** and that it was last asked **2 years ago**.

## Community answers

No answers have been contributed by the community yet.

## Related question

- [Given employee, department, and salary data stored in a dictionary, find the second maximum salary for each department.](https://www.aced.io/questions/6291/find-second-maximum-salary-department)

## Related courses

### [Data Engineering Interview Prep](https://www.aced.io/courses/data-engineering)

![Data Engineering Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/5XoOCgXlGqN2fa1zaroNWd/9a2e23df48a212bc00d352873feb2d6a/Data_Engineer_Interview_Prep_Hero_Image.jpg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for data engineering roles at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other top companies. The course includes mock interviews, frameworks, and advice from senior candidates, with practice in data modeling, pipeline design, SQL, coding, behavioral interviews, and more.

### [Behavioral Interviews: A Practical Guide for Engineers](https://www.aced.io/courses/eng-behavioral)

![Behavioral Interviews: A Practical Guide for Engineers](https://images.ctfassets.net/x78yjrjc11pq/47qcoHjzFZXE37GoacedkB/9d8e3f4910d8b06b21e76745cd9cbff3/AdobeStock_1142146335.jpeg?w=800&h=800&fm=webp&q=75)

We help engineers prepare for senior and higher-level behavioral interviews at FAANG and Tier-1 companies. Staff and principal engineers from Meta, Netflix, Google, and other companies made this course to help candidates avoid down-leveling, present past projects effectively, and communicate naturally.

## Your answer

Use the answer area to submit a response; submitting marks the question complete. Detailed company statistics for this question are available through [Upgrade](https://www.aced.io/upgrade?src=questions).

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F5087%2Fsql-top-three-salaries-per-department&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F5087%2Fsql-top-three-salaries-per-department). Opening a form does not execute a tool.