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

Very well done! We'll now see a very common mistake with recursive CTEs. What is the error? Let's see it in an exercise.

Exercise

We have changed the value 'Boss' in the anchor query to column last_name.

Try to run the query. What do you think will happen?