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
How to modify an existing stored procedure in ms sql server?
Why I have to use stored procedures?
Tell me about normalization in DBMS.
Explain indexed views?
What is the difference between a fill factor of 100 and 0?
How to delete an existing row with delete statements in ms sql server?
How to convert a table data in XML format in sql server?
Explain what is cte (common table expression)?
List the advantages of using stored procedures?
How to delete duplicate rows in sql server?
How many replicas are maintained for each SQL Azure database?
Do you know exporting and importing utility?
What are logical/boolean operations in ms sql server?
what is a check constraint?
Ways to improve the performance of a SQL Azure Database?