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

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

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  


What Are Three Rules to UseĀ UNION IN SQL SERVER

1 Answers  


What stored by the msdb? : sql server database administration

0 Answers  


what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,


what is IDE,DMV in sql server?

1 Answers   Value Labs,






What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,


What is a Stored Procedure?

8 Answers  


Can we use having clause without group by?

0 Answers  


What is difference between view and materialized view?

0 Answers  


Can you explain the role of each service?

1 Answers  


How does index makes search faster?

0 Answers   QuestPond,


difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,


Categories