Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / saurav kumar
Full outer join will give common + uncommon records from
both the table.
Suppose in TableA I have 5 records and TableB have 6
records. Both the table have 4 common records, means 4
records of TableA is common with TableB.
Then full outer join will give 4(common) + 1 (TableA)+ 2
(TableB) = 7 records.
Whereas Cross Join will give 5(TableA) * 6(TableB) = 30
records, also we can't put 'ON' condition with cross join.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What stored by the model?
Can you pass expressions to function parameters?
Is it possible in sql table to have more than one foreign key?
 Explain what is sql override for a source taLle in a mapping?
List the types of recovery model available in sql server?
What is normalization and what are the advantages of it?
Explain Normalization and DE normalization
What are the types of containers in ssis?
How to insert new line characters into strings?
Is a primary key unique?
What is the server name for sql management studio?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Can we call stored procedure in view in sql server?
Is candidate a key?
What is Federation Root Database?
