What are the type of joins? When do we use Outer and Self joins?
- 3 Answers
- 9352 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandra rekha
Types of joins:
->Inner join
->Outer join->1.Left Outer join
2.Right Outer join
->Cross join
->Equi join
->Natural join
->Self join
Outer join:-When we need all rows from one table and some
rows from the other table
Self join:-When one row in a table correlated with other
rows in the same table
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to update values in a table with update statements in ms sql server?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
what is isolation level at dead lock?
Mention the differences between sql server and mysql.
What stored by the master?
How to create a ddl trigger using "create trigger" statements?
Explain about integration services of Microsoft SQL server?
How do use Having,Group by,Group function in SQL?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Why is normalisation important?
What is format parameter in ssrs?
How to update multiple rows with one update statement in ms sql server?
How to get the query of a table in sql server?
What is the web service used for reporting services?
How to integrate the ssrs reports in application?
