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
Summary
12. Summary

Instruction

Good job! That query was really challenging!

It's time to wrap things up. What have we learned in this part?

  • It's impossible to put a CTE inside another CTE. However, each CTE can use previously-defined CTEs in the FROM clause.
  • Nested CTEs can be used to compute aggregate functions on a few levels.
  • If you need more than just the aggregate result in the outer query, you can use a small subquery.
  • CTEs can also be used to compare two (or more) groups of rows.

Are you ready for a short quiz?

Exercise

Click Next exercise to continue.