What is a SELF JOIN in SQL ?

Question

Vishal Jadav · Answer

Its a kind of join which join a table to itself.

Munesh Sharma · Answer

http://www.tutorialspoint.com/sql/sql-self-joins.htm

Rajeev Punhani · Answer

Self join means we are creating join on same table.Suppose we have a table employee
Emp_id,emp_name,manager_id.Now if we want to get emp_name ,manager_name from this table we need to do self join .Select a.emp_name,b.emp_name as managername from employee a,employee b where a.manager_id=b.emp_id

Ajeet Mishra · Answer

Same table is specified twice with two different aliases in order to match the data within the same table.

What is a SELF JOIN in SQL ?

4 Answers