The SELF Join is a regular join, but the table is joined with itself.
SELF JOIN : keyword used for joining a table with itself.
Table_name1/Table_name2 :The name of the table from where you want to fetch the data
Colume_Names :The name of the columns of the table based on which you want to join.
Let us consider a demo database with table Salary. Following is the structure of the table:
Figure 36.1. SALARY TABLE
The following SQL statement shows Self Join
Figure 36.2. SELF JOIN QUERY OUTPUT
Want More SQL Deep Dives