What are the type of joins? When do we use Outer and Self joins?
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 precedence constraint?
How to store and query spatial data?
Explain cdc and sql injection?
Is mysql better than sql server?
What are the types of user defined functions in sql server?
What command do we use to rename a db, a table and a column?
Why use view instead of a table?
Explain various data region available in ssrs with their use?
how to control the amount of free space in your index pages? : Sql server database administration
Is null vs coalesce?
How to change the name of a database user?
is there a column to which a default can't be bound? : Sql server database administration
Which command is used for user defined error messages?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Do you know concepts and capabilities of sql server?