Practice / Data & AI

SQL: top 2 salaries per department

Easy · Whiteboard

Tables employees(id, name, salary, dept_id) and departments(id, name). Return the two highest-paid employees in each department. What happens with ties?

Create a free account to answer it and get scored on what a strong answer covers.

InterviewMe: practise job interviews out loudAnswer real interview questions by voice and get a score, what worked, and what to fix for every answer. Built for co-op students, new grads and career switchers in Canada.Behavioural interview practice · Interview questions by role · PricingYou need JavaScript enabled to use the practice tool.