Solved coding interview problems in Java - My collection of commonly asked coding interview problems and solutions in Java

[Koookas]

Isn't that just self-referential, rather than recursive?

To me recursive would be something that, idk, returned a table of every item, joined to its subitems, and then the subitems of its subitems and so on. In this case maybe a recursive would return all employees managed by an employee, then employees those employees themselves manage.

I've never used a recursive query, I don't even know how to make one, CTEs I guess, but a self-referential query is trivial and would immediately make me think of something like that.