Self Join in sql

Hey lalit!

Self Join: Joining the table itself called self join. Self join is used to retrieve the records having some relation or similarity with other records in the same table. Here we need to use aliases for the same table to set a self join between single table and retrieve records satisfying the condition in where clause.

Here is the Syntax of Self Join :

SELECT e1.EmpId, e1.EmpName FROM EmployeeDetails e1, EmployeeDetails e2 wheree1.EmpId=e2.ManagerId;

Here is the link just check it out : self join query in sql server | self join example in sql server

hope it works for you. Mark accepted if it works. Thank you !

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Jadav11y ago
Accepted answer
Hey lalit!

Self Join: Joining the table itself called self join. Self join is used to retrieve the records having some relation or similarity with other records in the same table. Here we need to use aliases for the same table to set a self join between single table and retrieve records satisfying the condition in where clause.

Here is the Syntax of Self Join :

SELECT e1.EmpId, e1.EmpName FROM EmployeeDetails e1, EmployeeDetails e2 wheree1.EmpId=e2.ManagerId;

Here is the link just check it out : self join query in sql server | self join example in sql server

hope it works for you. Mark accepted if it works. Thank you !

+1