Interested to Buy Any Domain ? << Click Here >> for more details...
What are the type of joins? When do we use Outer and Self joins?
- 3 Answers
- 10246 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
What is 2nf in normalization?
Explain linked server in sql?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is user-defined function?
What have included columns when we talk about sql server indexing?
How to make a column nullable?
What security features are available for stored procedure?
How are the exceptions handled in sql server programming?
What is cube dimension? : sql server analysis services, ssas
To which devices can a backup be created and where should these devices be located? : sql server management studio
Explain how to use linked server?
How to enable/disable indexes?
When would you use sql joins?
What Are the Main Features of SQL Azure?
What is collation?
