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
Explain the stored procedure?
How to integrate the ssrs reports in application?
How to achieve Paging of records in SQL SERVER?
How to turn on the mssql api module in php?
Explain what are commit and rollback in sql?
What options are available to audit login activity? : sql server security
How to add an address record into adventureworkslt?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is transaction server auto commit?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Difference between DELETE and TRUNCATE?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is primary key, unique key, and foreign key?
How to list all field names in the result set using mssql_field_name()?