← Quiz: Recursive CTEs: all 15 questions
Quiz: Recursive CTEs · Question 14 of 15
How does SQL Server write a recursive CTE?
How does SQL Server write a recursive CTE?
- A.WITH RECURSIVE, like PostgreSQL
- B.It does not support recursive CTEs
- C.With just WITH; the word RECURSIVE is not used
- D.With CONNECT BY only
Answer & explanation
Correct answer: With just WITH; the word RECURSIVE is not used
SQL Server detects recursion from the CTE referring to itself.
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 →