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?

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


Please Help Members By Posting Answers For Below Questions

Do you know data definition language, data control language and data manipulation language?

981


What are secondary xml indexes?

983


How to enter date and time literals in ms sql server?

951


Can you force a query to use a specific index?

886


Differentiate between delete and truncate.

994


What are the advantages to use stored procedures?

1031


As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1061


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

984


What are the five characteristics of good data?

869


How except clause is differs from not in clause?

895


What are the new scripting capabilities of ssms? : sql server management studio

1000


What command do we use to rename a database?

1010


What are the grouping functions?

888


What is local temp table?

894


What is 2nf in normalization?

944