What is Self-Join?

A self-join is a type of SQL join where a table is joined with itself. It is used to combine rows from the same table based on a related column, typically with different aliases for the table to distinguish between the two instances. Self-joins are useful when working with hierarchical data or when you need to compare rows within the same table.

 A self join is a join of a table to itself.

                               When to use Self Join?? 

Now your task is to get the employees name with their manager names??



Post a Comment

Previous Post Next Post