Recursive Joint or Group By

Hi,

can somebody explain to me why I would need to apply a recursive joint for the employee example. Couldn’t I simply do this by grouping (GROUP BY) to both the employee_id and the reporting_to column?

I am sure there must be some reason why the recursive joint will be better, but could somebody please explain in what situations I would use recursive joints and when GROUP BY?

Thanks!

1 Like

Hi @muench.martino,

Try step 1 from: Guide: How to Ask a Good Question

7/8 top results have rich discussion on this.

1 Like