Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries in MS SQL Server

Introduction
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive ctes
Summary

Instruction

Excellent! Another modification is waiting for you.

Exercise

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.