Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and what does each do?
- 2 Answers
- 8297 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
How to create a new schema in a database?
Explain sql server service broker?
how many clustered indexes can be created on a table? : Sql server database administration
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is row-level compre?
What is nonclustered index on computed columns?
What command would you use to add a column to a table in sql server?
How to encrypt Strored Procedure in SQL SERVER?
Write an SQL query to obtain the 2nd highest salary.
What are number line correlation administrators will use while working with a subquery?
New concepts of sql server 2005 use in your project.
Does group by or order by come first?
What is the use of RDBMS?
What is an indice?
What is create command?
