Scenario SQL Question
Find Top 2 Employees by Salary in Each Department
Build mastery in Ranking Nth Value with this scenario-based SQL challenge and live execution support.
Problem Statement
Write a query to find the top 2 highest paid employees in each department. Show department_id, first_name, salary, and rank within department.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: