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
- 7433 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
Why do we need unique key in a table?
Is sql a microsoft product?
How much ram can sql express use?
What is pragma in pl sql?
Write the command to remove all players named sachin from the players table.
How many times can we commit in a loop?
Is sql scripting language?
What do you mean by field in sql?
How do I create a sql database?
What does pragma mean?
What is scalar and vector?
how to create a new table in mysql? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
What is a data definition language?
what is the bond code in materialized view?
