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
- 6681 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
Explain the working of primary key?
What is a full join sql?
What is bitemporal narrowing?
What is t-sql? : Transact sql
How do you create a db file?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Can we use ddl commands in pl sql?
How many triggers can be applied to a table?
what is error ora-03113: end-of-file on communication channel?
What is an exception in PL/SQL? What are the two types of exceptions?
how many groups of data types? : Sql dba
What is mutating sql table?
Can you selectively load only those records that you need? : aql loader
What is cursor explain with example?
How do I run a sql query in pgadmin 4?
