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 |
What does it mean to have quoted_identifier on? What are the implications of having it off?
What is the contrast between sql and pl/sql?
What is the difference between a view and a stored procedure?
What is a stored procedure?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Which sql server table is used to hold the stored procedure script?
What are the purposes and advantages stored procedure?
How to verify a user name with sqlcmd tool?
What is a with(nolock)?
What is the difference between delete and truncate statements?
Write a sql query to display the current date?
can primery key be a non clustered index?