🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.e.emp_id = previous.manager_id
  2. B.e.manager_id = previous.emp_id
  3. C.e.name = previous.name
  4. 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 →