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 |
Describe in brief authentication modes in sql server.
What do you mean by an execution plan? How would you view it?
How to send email from database?
What is the importance of concurrency control?
How can we improve performance by using SQL Server profiler?
How you would rewrite the sql query to return the customerid sorted numerically?
What command do we use to rename a db, a table and a column?
Explain hostprotectionattribute in sql server 2005?
What is the use of keyword with encryption.
How can you check the level of fragmentation on a table?
What are the OS services that the SQL Server installation adds?
What is a unique index?