Self Join in sql

Question

Hello friends can you tell me .what is self join in sql (with example).how we use it. Thanks in advance

Nilesh Jadav · 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 where e1 . 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 !