Diff. b/w Full Outer Join And Cross Join?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
What Are Three Rules to UseĀ UNION IN SQL SERVER
What stored by the msdb? : sql server database administration
what is node in sql server?
2 Answers CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,
what is IDE,DMV in sql server?
What are the advantages of using views. Why do we need views when we have SPs?
What is a Stored Procedure?
Can we use having clause without group by?
What is difference between view and materialized view?
Can you explain the role of each service?
How does index makes search faster?
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,