Scenario SQL Question

Assign Row Numbers to Employees by Salary

Build mastery in Ranking Nth Value with this scenario-based SQL challenge and live execution support.

Problem Statement

Write a query to assign a unique row number to each employee based on salary (highest to lowest). Show first_name, salary, and row_number.

employees

Strengthen your understanding with these targeted learning topics: