Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and what does each do?
- 2 Answers
- 8200 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
What are trace flags and mention a few common trace flags used with sql server?
What is the difference between createstatement and preparedstatement?
What is a coalesce function?
Does a full backup include transaction log?
How to count groups returned with the group by clause in ms sql server?
What are the differences between local and global temporary tables?
How to Check if table exists in sql server?
Mention the 3 ways to get a count of the number of records in a table.
What is xdr?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is the difference between ddl and dml?
What is trace flag in sql server?
What is an index in sql?
Which is the latest version of sql server and when it is released?
What are trace flags?
