Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Infinite looping
Processing trees with recursive CTEs
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.