Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and what does each do?
- 2 Answers
- 8163 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
Write SQL queries on Self Join and Inner Join.
What is perspective, have you ever created perspective? : sql server analysis services, ssas
How to make remote connection in database?
How to create sub reports?
How many databases can we create in a single server?
What is the template in sql?
Explain having clause?
Differentiate between SQL and ORACLE joins and write their syntax.
Explain acid?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What is a data source file?
What command is used to delete a table from the database in the sql server and how?
What are the requirements on sql server network connections?
What is the New in SQL server 2008?
How retrieve field names from the table in SQL through JAVA code?
