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

Introduction
The very basics
Infinite looping
Processing trees with recursive CTE
Processing graphs with recursive CTE
Summary

Instruction

Excellent. Another modification is waiting for you.

Exercise

Show the id, first, last name, superior_id of each subordinate of the employee with id = 2 (not only the direct subordinates, but also their subordinates etc.) and the employee herself.

Stuck? Here's a hint!

The anchor member now will not be the Boss, but the person with id = 2. Get rid of the unwanted columns too.