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 is the difference between DATETIME2 and DATETIME?
Is there any difference between primary key and unique with the not null condition?
What is stretch database in sql server?
How except clause is differs from not in clause?
Explain what are magic tables in sql server?
What are the source of constraints?
How do you create a data source?
optimization techinques
Explain different types of lock modes in sql server 2000?
Can truncate be rolled back?
How do I start sql server 2016?
What is a recursive stored procedure in sql server?
Explain indexed views?
What is command parameter in ssrs?
How you can get the list of largest tables in a database?
