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
What are conditional predicates?
What is the benefit of foreign key?
What is clustered index sql?
How do I remove sql developer from windows 10?
What are character functions in sql?
What is pl sql collection?
Write a sql query to convert all character to uppercase after hypen.
How do I truncate a word?
What is the use of %rowtype?
Write a sql query to find the names of employees that begin with ‘a’?
what are date and time functions in mysql? : Sql dba
Mention what is the plv (pl/vision) package offers?
What is a delimiter in sas?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
How to create an array in pl/sql?
