Problem 5 of 11 · Recursive CTEs & HierarchiesNext: Every team an incident can escalate to, despite the loops

00:00

Practice / SQL / Recursive CTEs & Hierarchies

WorkingGuided

MediumAbout 13 minRecursive CTEs & HierarchiesLesson: Recursive CTEs & Hierarchies (P21) →

Build the path from root to each employee

For each employee, build the path from the root down to them, names joined by > (e.g. Alice > Bob > Dan). Sort by emp_id.

Returnemp_idpath

Columns

employees3 columns

columntype

emp_idVARCHAR

nameVARCHAR

manager_idVARCHAR

The table

7 rows · 3 columns

employeesfirst 5 of 7 rows

emp_idnamemanager_id

e1AliceNULL

e2Bobe1

e3Carole1

e4Dane2

e5Erine2

If you get stuck

Show hint · 1 hint Walkthrough Reveal answer

Your query · runs in your browser⌘ Enter to run

Loading editor…

Output · run to see rows