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
- 7158 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
what is the use of friend function? : Sql dba
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
Is sqlite good enough for production?
Does inner join remove duplicates?
What is plpgsql language?
How much ram can sql express use?
What are pl/sql packages?
how can we submit a form without a submit button? : Sql dba
What is an exception in pl/sql?
What is the trigger in sql?
what is the bond code in materialized view?
What is database sql?
What is the advantage of index in sql?
