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
- 10223 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
Tell me what is log shipping?
What is surrogate key? : sql server analysis services, ssas
How can we determine what objects a user-defined function depends upon?
Explain what is sql server english query?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How fixed length strings are truncated and padded?
What is report snapshot?
Do you know the capabilities of cursors?
Which sql server is best?
What is the ‘fillfactor’?
What is the command used to check locks in microsoft sql server?
Explain syntax for dropping triggers?
What you can do to delete a table without the delete trigger firing?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is user-defined function?
