MySQL SELF JOIN

If a Table is joined to itself using one of the join types, then such a type of join is called SELF JOIN. To demonstrate MySQL SELF JOIN, let us create an Employee table with data as shown in the following image by executing the following script:

EXAMPLE: Now …