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 the most important ddl statements in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is sql entity?
Why do we use procedures in sql?
how to convert character strings to dates? : Sql dba
Explain what is sql?
What is the primary key?
Explain what is a view?
What is nosql example?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What are different functions in sql?
Can you join views in sql?
What is coalesce in sql?
I need a function for a train ticket reservation please answer it thanks in advance
How do I save the results of sql query in a file?
