Scenario SQL Question
Rank Employees Within Each Department
Build mastery in Ranking Nth Value with this scenario-based SQL challenge and live execution support.
Problem Statement
Rank employees by salary WITHIN their department. Use RANK so ties share a rank. Show first_name, last_name, department_id, salary, dept_salary_rank, ordered by department_id, dept_salary_rank, employee_id.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: