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
- 10180 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 execute a sql statement using mssql_query()?
Show Practically Sql Server Views are updatable?
Explain about temporary stored procedure?
What is the difference between char, varchar and nvarchar?
How does stuff differ from the replace function?
What is the current pricing model of SQL Azure?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is page in sql server?
Difference between Logical Page and Physical Page in SSRS.
how to invoke a trigger on demand? : Sql server database administration
Is null vs coalesce?
What are the different acid properties?
How to divide query output into multiple groups with the group by clause in ms sql server?
What is a trace frag?
What is the server name for sql management studio?
