Skip to content
SQLSimplified
hardemployeesrecursive-cte

Manager Chain Depth

Problem

Return each employee's first_name, last_name, and their depth in the management hierarchy (top managers = 1), ordered by depth then last_name.

Try It

Loading playground environment...

Hint

Solution

Next Problem