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

Diff. b/w Full Outer Join And Cross Join?

Question Posted / ramesh

Answers were Sorted based on User's Feedback



Diff. b/w Full Outer Join And Cross Join?..

Answer / ramesh

Full Outer Join requires a condition and related column in
the table.
Cross Join requires with out condition and no related
columns in the tables.

Is This Answer Correct ?    5 Yes 1 No

Diff. b/w Full Outer Join And Cross Join?..

Answer / saurav kumar

Full outer join will give common + uncommon records from
both the table.
Suppose in TableA I have 5 records and TableB have 6
records. Both the table have 4 common records, means 4
records of TableA is common with TableB.
Then full outer join will give 4(common) + 1 (TableA)+ 2
(TableB) = 7 records.

Whereas Cross Join will give 5(TableA) * 6(TableB) = 30
records, also we can't put 'ON' condition with cross join.

Is This Answer Correct ?    4 Yes 0 No

Diff. b/w Full Outer Join And Cross Join?..

Answer / samba shiva reddy . m

Full Outer join it will take all the records from the both the tables.
Example:
Table1 : emp
______________
empid empname
______________
1 samba
______________
2 Anju
______________
NULL Shiva
______________
5 NULL
______________

Table2 : user

______________
uid uname
______________
1 raju
______________
2 Khan
______________
3 Sripal
______________
4 Sathosh
______________
NULL Srinu
______________
9 NULL
______________

We will write the Full Outer join on both the table

Select * from emp full outer join [user] on emp.empid=[user].uid

the result will be both the tables with NULL vslues

but in the cross join it is bsed on the rows

in the cross join it will give the combination of all rows

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

What is the purpose of the model database?

0 Answers  

What is abstracting periodical?

0 Answers  

How can you find out which stored procedures are recompiling?

0 Answers  

What is the main purpose of having conversation group?

0 Answers  

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

Why use “in” clause in sql server?

0 Answers  

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

What is the use of partition by in sql server?

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 inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

0 Answers  

What is collation?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories