Answer 1

Hariom Gupta Hey, a self-join is a query in which a table is joined (compared) to itself. Self-joins are used to compare values in a column with other values in the same column in the same table. One practical use for self-joins is obtaining running counts and running totals in an SQL query.

To be honest I've never used it 🙂