ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
explain different types of jions with examples briefly?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: explain different types of jions with examples briefly?
Answer
# 1
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 ?    2 Yes 0 No
Ramesh
 
  Re: explain different types of jions with examples briefly?
Answer
# 2
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 ?    6 Yes 1 No
Vijay
 
 
 
  Re: explain different types of jions with examples briefly?
Answer
# 3
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 ?    1 Yes 1 No
Dinesh .
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the datatype returned by count(*) Asian-CERC18
how to find number of columns in a table in sql server 2000 and 2005 also Virtusa7
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?  1
What are the main control-of-flow T-SQL constructs?  1
How to create logins using windows Authentication mode?  2
what is advantages in sql 2005 over sql 2000?  4
How to work on DTS?what is the main requirement? ivan1
What are explicit and implicit transactions?  2
Write a query to delete duplicate records in SQL SERVER Infosys19
What is normalization in Database ?  4
what is Data Transformation Services (DTS) ?can u explain me in detail? TCS5
Explain the storage models of OLAP?  1
What is Deadlock? Satyam3
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1; Patni9
hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000  3
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??  8
What is a materialized view?  2
How do we get current date in SQL Server 2000, Oracle, MS Access?  11
write the query for taking database restore in sql?  2
can you any body tell me the how to decrease the logfile  4
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com