ProAnswers.org

What is a self join and give an example.

What is a self join and give an example.

Self join means Joining two instances of a same table.

Sample SQL : SELECT A.EMPNAME , B.EMPNAME FROM EMP A, EMP B WHERE A.MGRID =B.EMPID