SQL Practice Logo

SQLPractice Online

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