Scenario SQL Question
Compare Employee Salary with Previous Employee (by Hire Date)
Build mastery in Ranking Nth Value with this scenario-based SQL challenge and live execution support.
Problem Statement
For each employee, show their hire_date, salary, and the SALARY of the previous person hired (NULL for the first). Order by hire_date.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: