explain different types of jions with examples briefly?

Answers were Sorted based on User's Feedback



explain different types of jions with examples briefly?..

Answer / vijay

The SQL join command is used to join two or more tables. At
times you may need to join two or more tables to retrieve
the information you need from your SQL database

Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join

3.Cross Join
4.Self Join

Is This Answer Correct ?    13 Yes 2 No

explain different types of jions with examples briefly?..

Answer / ramesh

Basically Joins are used to get result from two or more
tables and there are two types of joins
inner join and outer join
Inner join : a join of two or more tables which omits the
blank rows while checking

Outer join is subcatogorised in to left outer join and right
outer join. Which includes blank rows in specifed side if
condition satisfies.
Simple outer join is combination of left and right outerjoins.
Apart from these there are
Natural join : cartisian product
Equi join : which includes = operator in condition
NonEqui join : All conditional joins which doesn't uses = in
there conditions.

Is This Answer Correct ?    3 Yes 1 No

explain different types of jions with examples briefly?..

Answer / dinesh .

16)Join
Table1:Record
1 a
2 b
3 b
4 b
4 c
Table2:Record1
1 a 2
2 b 2
3 c 24
5 f 2
8 g 2
10 j NULL
Inner Join:
Qry1:select record_name,recordcount from record inner join
record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
qry2:select p.record_name,q.recordcount from record p,
record1 q where p.record_id=q.record_code
Result:
a 2
b 2
b 24
Left Join
qry3:select record_name,recordcount from record left join
record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
b NULL
c NULL
Right Join
qry4:select record_name,recordcount from record right join
record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
NULL 2
NULL 2
NULL NULL
Left Outer Join
qry5:select record_name,recordcount from record left outer
join record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
b NULL
c NULL
Right Outer Join
qry6:select record_name,recordcount from record right outer
join record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
NULL 2
NULL 2
NULL NULL
Full Outer Join
qry7:select record_name,recordcount from record full outer
join record1 on
record.record_id=record1.record_code
Result:
a 2
b 2
b 24
b NULL
c NULL
NULL 2
NULL 2
NULL NULL

"Their is No Left Inner Join,Right Inner Join in SQL Server

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  


What is a file group?

0 Answers  


What do you mean by SQL injection attack?

0 Answers   Ittiam Systems,


How to assign null values to variables or columns?

0 Answers  






what are batch in sql server?

2 Answers   Satyam,


What is sql server 2000 work load governor?

0 Answers  


Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,


What is user-defined multi-statement table-valued function?

0 Answers  


What is the difference between system objects and user objects?

0 Answers   HCL,


How to check parameter value in stored procedure sql server?

0 Answers  


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  


Categories