Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between cross join and Full outer
join?
- 1 Answers
- 7865 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
What are the differences between user defined functions and stored procedures?
What is BCP? When does it used in sql server 2012?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is the importance of concurrency control?
What are sql servers used for?
What are the hotfixes and patches in sql server?
What are the five major components of a dbms?
What is ms sql server service broker?
What is a trace frag?
What do I need to start working with sql studio? : sql server management studio
What is the maximum length of an alert name?
What is the security principal at the database level that represents your session?
Can we shrink data file in sql server?
Explain “row_number()” in sql server with an example?
What is resultset concur_updatable?
