Interested to Buy Any Domain ? << Click Here >> for more details...
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
How would you reference column values before and after you have inserted and deleted triggers?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is the difference between stored procedure and view?
How do I run a script in sql developer?
What are the two types of exceptions.
How can get second highest salary in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
What is sql mysql pl sql oracle?
What is the difference between in and between in sql?
Why are aggregate functions called so?
what is 'mysqlimport'? : Sql dba
What is sharding in sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
How do I order columns in sql?
