Interested to Buy Any Domain ? << Click Here >> for more details...
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p
if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately
Can anyone help on this?
- 2 Answers
- 7270 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit sinha
equijoin will produce only the common record.
A right outerjoin B will produce all common records with
remaining records from B . The point to be noticed here is A
is right outerjoined to B which means common records from A
as well as remaining records from B
Opposite things happen with A left outerjoin B
Full outer join means common records and remaining records
from both the tables
crossjoin means multiplications
suppose A has 4 records and B has 4 records.
Total output will have 16 records.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How can you load microsoft excel data into oracle? : aql loader
what is error ora-03113: end-of-file on communication channel?
What is data profiling in sql?
Why is sql important?
What is data manipulation language?
Which certification is best for sql?
What are the types of queries in sql?
What is ttitle and btitle?
What's the difference between a primary key and a clustered index?
What does select count (*) mean in sql?
Can you rollback after commit?
What are different clauses used in sql?
What is the process of debugging?
How to execute a stored procedure?
What is a Mapplet?
