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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 ?    0 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 ?    1 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 ?    0 Yes 0 No
Dinesh .
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
explain different types of jions with examples briefly? Zensar3
What does the INSTEAD OF trigger do?  2
How can you get @@error and @@rowcount at the same time?  4
What is a Join in SQL Server?  1
What are the main control-of-flow T-SQL constructs?  1
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person  5
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?  1
Differnce between sel server 2000 and 2005  3
Which virtual table does a trigger use?  3
Different Types of Functions ? Satyam2
How to Execute an Operating System Command From Within SQL Server ?  2
what is web server? Satyam3
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ? Perot-Systems7
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?  1
Wht is Stuff in sql ser  1
What are the two types of concurrency?  2
I have student marks in a student table. I need second highest mark .Then what will the query for this? Wipro21
Is it possible to delete duplicate rows in a table without using a temporary table ?  5
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? HCL1
Hi..here i would like to know the Backup and Restore models? HCL2
 
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