[Solved] How do you correctly declare a recursive CTE named descendants in PostgreSQL? — Ans: WITH RECURSIVE descendants AS (SELECT * FROM table_name WHERE condition) | PostgreSQL

PostgreSQL - Common Table Expressions

How do you correctly declare a recursive CTE named descendants in PostgreSQL?

AWITH RECURSIVE descendants AS (SELECT * FROM table_name WHERE condition)

BWITH descendants RECURSIVE AS (SELECT * FROM table_name WHERE condition)

CWITH RECURSIVE AS descendants (SELECT * FROM table_name WHERE condition)

DRECURSIVE WITH descendants AS (SELECT * FROM table_name WHERE condition)

Step-by-Step Solution

Solution:

Step 1: Use the WITH RECURSIVE clause
This is the correct way to start a recursive CTE in PostgreSQL.
Step 2: Name the CTE immediately after WITH RECURSIVE
The CTE name descendants follows directly after.
Step 3: Provide the CTE query inside parentheses
The recursive query is enclosed in parentheses.
Final Answer:
WITH RECURSIVE descendants AS (SELECT * FROM table_name WHERE condition) -> Option A
Quick Check:
Check the order: WITH RECURSIVE <name> AS (…) [OK]

Quick Trick: Start with 'WITH RECURSIVE' followed by CTE name [OK]

Common Mistakes:

Master "Common Table Expressions" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

How do you correctly declare a recursive CTE named descendants in PostgreSQL?