A self join query is used to join a table to itself in a SQL query.

• Self join is used when a table needs to be joined with itself to compare rows within the same table.

• It requires aliasing the table wi...read more