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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is Cross Join

Question Posted / ramesh

Answers were Sorted based on User's Feedback



What is Cross Join..

Answer / ramesh

A join with out condition is called CrossJoin.
It also called as cartesionjoin.
It produces resultset where every row is first table joined
with every row in second table.

Is This Answer Correct ?    5 Yes 1 No

What is Cross Join..

Answer / kuldeep sharma

SQL Cross Join...>Cartesian product of both tables.

Example:
Let left table has 10 rows and right table has 8 rows then
SQL CROSS Join will return 180 rows combining each record
of left table with all records of right side table.
Consider the following example of CROSS Join:



USE PUBS
SELECT AU_FNAME, AU_LNAME, PUB_NAME
FROM AUTHORS CROSS JOIN PUBLISHERS
ORDER BY AU_FNAME



Above cross join will return 23 * 8 = 184 results by
multiplying each row of authors table with publishers table.

Is This Answer Correct ?    1 Yes 0 No

What is Cross Join..

Answer / colin

A small error kuldeep..if left table has 10 rows n right
table has 8 rows..then a cross join wud return 80 rows
(10*8)..besides dis ur totally ryt.. Cross joins are also
called cartesian product..

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Why do we backup Active Directory ?

0 Answers  

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

0 Answers  

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

How to find the source of a table in sql server?

0 Answers  

What are the basic features of a trigger in ms sql server?

0 Answers  

How to send email from database?

0 Answers  

Can you explain different types of locks in sql server?

0 Answers  

What is oltp (online transaction processing)?

0 Answers  

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

Explain syntax for disabling triggers?

0 Answers  

default databases available in sql server and there uses ?

4 Answers   TCS,

What factors you will consider calculating the storage requirement for that view?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories