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

Employees & Departments

Loading database engine...

Hint

Solution

Search

Search lessons, functions, examples, and practice problems