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 write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What programming language would you use to create embedded functions in ssrs?
What do you mean by authentication modes in sql server?
What is report snapshot in ssrs?
How to generate create view script on an existing view?
How to create new tables with "create table" statements in ms sql server?
What are the difficulties faced in cube development? : sql server analysis services, ssas
How to connect Azure federated root database and apply federation in entity framework?
Can a table be moved to different filegroup?
What are the drawbacks of reporting in ssrs?
How you can minimize the deadlock situation?
How to find the second highest salary of an employee?
What is page in sql server?
What is a unique key constraint?