SQL - Common Table Expressions (CTEs)
Which of the following is the correct basic syntax to start a recursive CTE in SQL?
Which of the following is the correct basic syntax to start a recursive CTE in SQL?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall recursive CTE syntax
The standard syntax starts withWITH cte_name AS (anchor_query UNION ALL recursive_query).Step 2: Check options for correct form
WITH cte_name AS (SELECT ... UNION ALL SELECT ... FROM cte_name ...) correctly shows the anchor and recursive parts combined withUNION ALLand references the CTE name in the recursive part.Final Answer:
WITH cte_name AS (SELECT ... UNION ALL SELECT ... FROM cte_name ...) -> Option AQuick Check:
Recursive CTE syntax = WITH + UNION ALL + self-reference [OK]
Quick Trick: Recursive CTE uses WITH + UNION ALL + self-reference [OK]
Common Mistakes:
- Using CREATE instead of WITH
- Omitting UNION ALL
- Not referencing the CTE name recursively
Master "Common Table Expressions (CTEs)" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes