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 the use of cursor ? how cursor allocate context area for executing the sql statement?
What is pl sql quora?
What is the difference between microsoft access and sql server?
how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
Where is sql database stored?
What is the purpose of a secondary key?
What is rank () in sql?
Can we group by two columns in sql?
How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
What is anonymous block in sql?
What is #table in sql?
what is mean by forward declaration and where we'll use it.