Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and what does each do?
- 2 Answers
- 8071 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
When we should use and scope of @@identity?
Do you know nested transaction?
What is use of except clause? How does it differ from not in clause?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is dbcc?
What are the key configuration files for sql server reporting services ?
Difference between report and query parameter. Why do we need different type of parameter?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Explain having clause and where clause?
How to use subqueries with the in operators in ms sql server?
What is the difference between ddl and dml?
What is the recursive stored procedure in sql server?
Explain what are the authentication modes in sql server?
Can one drop a column from a table?
How to use the inserted and deleted pseudo tables?
