Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is the difference between cross join and Full outer
join?



What is the difference between cross join and Full outer join?..

Answer / 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

More SQL Server Interview Questions

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  


What is a trace frag? Where do we use it?

0 Answers  


What do you understand by a view?

0 Answers  


How to find tables without indexes?

0 Answers  


How do I view a procedure in sql server?

0 Answers  


your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  


Explain important index characteristics?

0 Answers  


Tell me what is the order in which the sql query is executed?

0 Answers  


difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,


Why do we use stored procedures in sql server?

0 Answers  


How to create a ddl trigger using "create trigger" statements?

0 Answers  


How to execute a sql statement using odbc_exec()?

0 Answers  


Categories