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 pl sql collection?
How many indexes can be created on a table in sql?
How to write a query to show the details of a student from students table whose
Why we use stored procedure instead of query?
Write the command to remove all players named sachin from the players table.
How is data stored in sql?
What are sql built in functions?
Are sql database names case sensitive?
What is varchar example?
What is trigger in pl sql with examples?
How do you concatenate in sql?
What is the usage of when clause in trigger?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is the source code of a program?
what is sql server agent? : Sql dba
