2
Answers

When and why should we use a self join in SQL?

Photo of Kripanshu Kumar

Kripanshu Kumar

May 19
198
1

I came across the concept of a self join while learning SQL. I understand that it’s a join where a table is joined with itself, but I’m not entirely clear on when this is necessary or useful.

Answers (2)