What are the type of joins? When do we use Outer and Self joins?
- 3 Answers
- 9594 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 ems sql management studio? : sql server management studio
What is the use of set nocount on/off statement?
How to create a scrollable cursor with the scroll option?
What is a full text index?
How to call stored procedure using http soap?
What stored by the tempdb ? : sql server database administration
Explain few examples of RDBMS?
How to create prepared statements using odbc_prepare()?
What is the difference between delete and truncate statements?
How many databases instances are there in sql server 2000?
what is a live lock? : Sql server database administration
What are the authentication modes in sql server? How can it be changed?
How do you rebuild an identity column?
How to locate and take substrings with charindex() and substring() functions?
what are triggers? : Sql server database administration
