Answer Posted / 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 |
Post New Answer View All Answers
What is the use of non clustered index?
How do I run sql?
What is %s in sql?
what are the different type of normalization? : Sql dba
What is flag in sql?
Why trigger is used in sql?
What does t sql mean?
Define a temp table?
What is scalar function?
How to raise user-defined exception with custom sqlerrm ?
What is data types in sql?
What is delimiter in pl sql?
Explain what is an index?
What is transaction control language (tcl)?
What is an example of translating a date into julian format?
