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

Question Posted / ramesh

3 Answers
7548 Views
I also Faced
E-Mail Answers

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

Where sql server usernames and passwords are stored in a sql server?

0 Answers

Define self join?

0 Answers

Is it possible to create trigger on views?

0 Answers

What is data compression?

0 Answers

Which sql server table is used to hold the stored procedure script?

0 Answers

can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.

3 Answers

What is the security principal at the database level that represents your session?

0 Answers

How do I port a number to sql server?

0 Answers

Explain sub-query?

0 Answers

How dts is used to extract, transform and consolidate data?

0 Answers

what is the system function to get the current user's user id? : Sql server database administration

0 Answers

How to find the date and time of last updated table?

3 Answers

For more SQL Server Interview Questions Click Here