What is the difference between cross join and Full outer
join?
Answer Posted / 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 View All Answers
Do you know data definition language, data control language and data manipulation language?
What are secondary xml indexes?
How to enter date and time literals in ms sql server?
Can you force a query to use a specific index?
Differentiate between delete and truncate.
What are the advantages to use stored procedures?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What are the five characteristics of good data?
How except clause is differs from not in clause?
What are the new scripting capabilities of ssms? : sql server management studio
What command do we use to rename a database?
What are the grouping functions?
What is local temp table?
What is 2nf in normalization?