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
Where actually sql azure database is hosted?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How do you use a subquery to find records that exist in one table and do not exist in another?
Explain the working of sql privileges?
What do you understand by check constraint in sql server?
How to list all tables in the database using odbc_tables()?
What authentication modes does sql server support?
How do I save a stored procedure in sql server?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Explain comment on transactions?
What are the different types of sub-queries?
What are sql azure firewall rules?
What is store procedure? How do they work? When do you use?
what is bit datatype? : Sql server database administration
What are the different types of collation sensitivity in sql server?