Loading

How to use Self Join in SQL Server

Gaurav Malviya

Follow Steps:

--1.Creating the Employee table

CREATE TABLE Emp(emp_id int, manger_id int,employee_name varchar(20))

--2.Inserting the value

1 Comment

Join the conversation! Your thoughts help the community grow.

INSERT INTO Emp VALUES(1,1,'T1'),(2,1,'T2'),(3,2,'T3'),(4,1,'T4')

--3.The self join query

SELECT emp.emp_id,emp.employee_name [Emb], mgr.employee_name [Manager] FROM Emp, Emp mgr WHERE emp.manger_id = mgr.emp_id