[Solved] What will this query output?WITH RECURSIVE seq AS (SELECT 5 AS val UNION ALL SELECT val - 1 FROM seq WHERE val > 2) SELECT * FROM seq ORDER BY val; | SQL

SQL - Common Table Expressions (CTEs)

What will this query output?

WITH RECURSIVE seq AS (SELECT 5 AS val UNION ALL SELECT val - 1 FROM seq WHERE val > 2) SELECT * FROM seq ORDER BY val;

A5, 4, 3, 2

B2, 3, 4, 5

C5, 4, 3

D3, 4, 5

Step-by-Step Solution

Solution:

Step 1: Understand base and recursion
Base returns 5, recursion subtracts 1 while val > 2, so values 5,4,3,2 are generated.
Step 2: Note ORDER BY clause
Ordering by val ascending gives 2,3,4,5 in output.
Final Answer:
2, 3, 4, 5 -> Option B
Quick Check:
Order by val ascending = 2,3,4,5 [OK]

Quick Trick: ORDER BY changes output order, recursion generates values [OK]

Common Mistakes:

Master "Common Table Expressions (CTEs)" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will this query output?