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

Quite impressive, right? We'll now help you construct the query step-by-step so that you understand how it works.

Exercise

In the first step, we'll show information about the boss. This is the only person in the table that has a NULL superior_id. For that person, show the id, first_name, last_name, superior_id, and a column called path with 'Boss' inside.

Stuck? Here's a hint!

Remember that you can check whether a value is NULL using:

WHERE column_name IS NULL