What are the different types of joins and what does each do?
Answers were Sorted based on User's Feedback
Answer / swapna
Different types of joins are normal joins and set joins.
Normal joins are outer joins and inner joins.
Inner joins are cross join,equi join,non-equi joins,self
joins.
Outer joins are left outer join,right outer join,full outer
joins.
Set joins are union,union all,intersect,minus.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sachin patil
Diff types of join
1. Inner
2.Left Outer
3.Right Outer
4.Cartesian
5.Self Join
Is This Answer Correct ? | 2 Yes | 0 No |
Explain isolation levels that sql server supports?
Explain SELF JOIN ?
What is difference between line feed ( ) and carriage return ( )?
Explain the xml support sql server extends?
How to configure odbc dsn with different port numbers?
Explain powershell included in sql server 2008?
How to list all login names on the ms sql server?
How much memory that we are using in Logshipping Concept?
Define clusters?
What is the maximum size of sql server database?
What are the purposes and advantages stored procedure?
How many types of attribute relationships are there? : sql server analysis services, ssas