|SQL - Structured Query Language|
Self join is used to retrieve list of common columns matched data value records within a table with two different columns. The following self join is used to retrieve list of Employee and their Manager information that matched with Emp_Code and MGR_Code.
Note: For Demo, create EMP_Test Table and then INSERT sample records.
Query Output Screen
* * * * *