Self join is used to join a table with itself.

• Use table aliases to differentiate between the two instances of the same table

• Specify the join condition using the aliases

• Example: SELECT e1.employee_name...read more