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 PostgreSQL

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

Instruction

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

Exercise

In the anchor query, we have changed the value 'Boss' to the column last_name.

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