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 does truncate do?
Can foreign key be deleted?
How to name query output columns in ms sql server?
What are the differences between decimal and float in ms sql server?
What are pessimistic lock and optimistic lock?
What is order of B+tree?
How to loop through the result set with @@fetch_status?
Do you know what is user defined datatypes and when you should go for them?
explain different types of backups avaialabe in sql server? : Sql server database administration
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is #table in sql server?
What is trigger explain with program?
What is optimization and its types?
Where are sql server usernames and passwords stored in the sql server?
What is data source document?