Sep 9, 2019 in Spark Sql
Q:

SQL Self JOIN

1 Answer

0 votes
Sep 9, 2019

SQL Self JOIN

A self JOIN is a regular join, but the table is joined with itself.

Self JOIN Syntax

SELECT column_name(s)
FROM table1 T1, table1 T2
WHERE condition;

T1 and T2 are different table aliases for the same table.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance
...