Sololearn: Learn to Code
+ 18
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 🙂
21st Jan 2019, 1:58 PM
r8w9 - avatar