The very basics
Infinite looping
Processing trees with recursive CTEs
22. Exercise 2
Processing graphs with recursive ctes


Excellent! Another modification is waiting for you.


Show the Id, FirstName, LastName, and SuperiorId of each subordinate of the employee with the Id = 2. Show not only the direct subordinates, but also their subordinates, etc. Also show the employee with the ID of 2.

Stuck? Here's a hint!

The anchor member is now the person with Id = 2, not the boss. Get rid of all the unwanted columns, too.