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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mandayan
not pasible to help u becouse u have to give with data ok
Is This Answer Correct ? | 1 Yes | 1 No |
What is Temp Table and type of temp table?
What is coalesce sql?
Why do we use procedures in sql?
How many subqueries can be nested in a statement?
Wat is SGA ?
What plvcmt and plvrb does in pl/sql?
What is primary and foreign key?
how many columns can be used for creating index? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
HP Interview -2016 Unix 1) grep command in unix 2) what is set command
I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL
5 Answers Doyensys, Infosys, Metric Stream,
How many postgresql users are there, worldwide?