What is a self join ?
Answers were Sorted based on User's Feedback
Answer / anil_abbireddy
A table is joined itself is called self join or Self
referential integrity.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / rupesh.dbms@gmail.com
It is the join in which result is obtained by equating two
coloumns with same values of one table for example
emp(eno,ename,mgrno) eno is primary key and mgrno is
recursive foreign key
select e.eno,e.ename,m.mgrno,m.ename mgrname
from emp e, emp m
where m.eno=e.mgrno;
note : one table emp is replicated as m , e and then
result is obtained.
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / anbu
Self join is defined as a table is viewd by two different
ways and then the join can be done with the same table.
By another way the definition is 'A table can be joined
with itself using sel join'.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / ram
Normally we joins for retrieve data from more than 1 table
In some cases we need to join 1 table itself to join itself
condition is table having two column with same data type &
size but name are different
In emp table empno & mgrno are two columns example for this
select ename,job,sal,e.empno,m.mgrno from emp e inner join
emp m on m.mgrno=e.empno
Is This Answer Correct ? | 2 Yes | 2 No |
What is the left table in sql?
Does sql require a server?
What is sql keyword?
What's the procedure?
What is Difference Between Unique and Primary Key Constraints?
please explain database architecture..
How to start the command-line sql*plus?
how to use 'mysql' to run sql statements? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
What does the sign mean in sql?
What are the events on which a database trigger can be based?
Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.