← Quiz: Recursive CTEs: all 15 questions
Quiz: Recursive CTEs · Question 9 of 15
What rule must the anchor and the recursive part follow?
What rule must the anchor and the recursive part follow?
- A.They must read different tables
- B.The recursive part must return fewer columns
- C.They must return the same number of columns, in the same order
- D.They must both use GROUP BY
Answer & explanation
Correct answer: They must return the same number of columns, in the same order
They are combined with UNION ALL, so their columns must line up.
Can you get the rest right without peeking?
Take the timed Quiz: Recursive CTEs quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →