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

Okay, let's go one step further.

Exercise

The result of the query you wrote in the previous exercise is already in the template. Your task is to show the boss and their immediate subordinates. For them, the path column should contain 'Boss->' plus the last_name of the respective employee. Take the results from the template and UNION them with the boss's immediate subordinates.

Stuck? Here's a hint!

Use the concatenation operator ( || ) to create the whole path.