What is the difference between cross join and Full outer
join?



What is the difference between cross join and Full outer join?..

Answer / soma shaw

A cross join is a Cartesian join. for sets of A and B rows, you'll get a result of A * B rows. A full join will match all possible rows, meaning it will return AT MOST A + B rows.

Is This Answer Correct ?    18 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  


What is the purpose of forms?

0 Answers  


Advantages and disadvantages of stored procedures.

2 Answers   HCL,


What is the difference between executequery () and executeupdate ()?

0 Answers  


What is inner join in sql server joins?

0 Answers  






What are the recovery models in sql server 2000?

0 Answers  


What are the advantages of mirroring?

0 Answers  


How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,


What is executereader?

0 Answers  


How you can get the list of largest tables in a database?

0 Answers  


Differentiate between mongodb vs. Sql server?

0 Answers  


Which institute is best for SQL Server 2005 Training?

6 Answers  


Categories