Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between cross join and Full outer
join?
- 1 Answers
- 7840 Views
- HP, Standard Bank, I also Faced
- E-Mail Answers
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
Is it important for a database administrator to understand the operating system and file access?
What is the default sql server instance name?
How secure is sql server database?
How to locate and take substrings with charindex() and substring() functions?
What is sub-query in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What are the new features in sql server 2016?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is the correct order of the logical query processing phases?
Can you edit the .rdl code associated with a linked report?
What is query optimization process?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How you provide security to cube? : sql server analysis services, ssas
Why and when do stored procedure recompile?
What is spatial and temporal data?
