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
How to make conditional sum in ssrs?
How to list all user defined functions in the current database?
Give the query of getting last two records from the table in SQL SERVER?
Explain about extended stored procedure?
What is indexing in sql server with example?
Do you know the capabilities of cursors?
Explain multiserver query
How to enable tcp/ip protocol on a sql server?
What is server-level principal?
What are different types of raid levels?
How to create a testing table with test data in ms sql server?
What are page splits?
What is lock escalation? : sql server database administration
What is SQL Azure Fabric?
what is a check constraint?
