Scenario SQL Question
Rank and Dense Rank for Salary Positioning
Build mastery in Ctes Window with this scenario-based SQL challenge and live execution support.
Problem Statement
For each department, show employees with their salary rank (RANK) and dense rank (DENSE_RANK). Include employee name, salary, department name, rank, and dense_rank.
Relevant Tables
employeesdepartments