[Solved] What will be the result of this query?WITH RECURSIVE sequence AS (SELECT 2 AS val UNION ALL SELECT val * 2 FROM sequence WHERE val < 8) SELECT * FROM sequence ORDER BY val; | SQL

SQL - Common Table Expressions (CTEs)

What will be the result of this query?

WITH RECURSIVE sequence AS (SELECT 2 AS val UNION ALL SELECT val * 2 FROM sequence WHERE val < 8) SELECT * FROM sequence ORDER BY val;

A2, 4, 6, 8

B2, 4, 8

C2, 4, 8, 16

D2, 4

Step-by-Step Solution

Solution:

Step 1: Analyze anchor member
Starts with val = 2.
Step 2: Analyze recursive member
Each next val is val * 2, but only if val < 8.
Step 3: Generate sequence
2 (anchor), then 4 (2*2), then 8 (4*2). Next would be 16 (8*2), but 8 < 8 is false, so recursion stops.
Final Answer:
2, 4, 8 -> Option B
Quick Check:
Multiply by 2 until val < 8 [OK]

Quick Trick: Multiply val by 2 until less than 8 [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 be the result of this query?