← Quiz: Recursive CTEs: all 15 questions
Quiz: Recursive CTEs · Question 12 of 15
To walk UP from Arjun to the top manager, how does the recursive part join?
To walk UP from Arjun to the top manager, how does the recursive part join?
- A.e.emp_id = previous.manager_id
- B.e.manager_id = previous.emp_id
- C.e.name = previous.name
- D.It needs a CROSS JOIN
Answer & explanation
Correct answer: e.emp_id = previous.manager_id
Each round finds the manager of the row found in the last round.
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 →