Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and what does each do?
- 2 Answers
- 8189 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain system scalar functions?
Tell me what are the essential components of sql server service broker?
Explain differences between web edition and business edition?
What is the benefit of normalization?
How does normalization work?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is the recovery model?
What is factless fact table? : sql server analysis services, ssas
What is self join in sql server joins?
what are acid properties? : Sql server database administration
Define tool Manage Statistics in SQL Server 2000 query ?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is scrollable cursor?
How to select some specific columns from a table in a query in ms sql server?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
