How to use self join in sql server and what's it's important.

Question

AVADHESH PATEL · Answer

Self Join Self join correlates rows of a table with the other rows of the same table. It is used when a table has to be joined to itself to produce results.Example First you have to create a table EmpTable and enter the details like this:EmpID EmpName EmpMgrID1 Smith 2 2 Sai 33 Suresh 14 Bill 25 Steve 4 OutputEmpName ManagerSuresh SmithSmith SaiBill SaiSai SureshSteve Bill

forum

How to use self join in sql server and what's it's important.

Can you answer this question?

1 Answers