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
How many categories of data types used by sql server?
Can you explain what are commit and rollback in sql?
What is the difference between substr and charindex in the sql server?
How many tables can be joined in SQL Server?
What are the dmvs?
What are the commands used in DCL?
What is reference section?
Are null values the same as that of zero or a blank space?
Mention the differences between local and global temporary tables.
What are unicode character string data types in ms sql server?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How we can compare two database data?
What happens if an integer is too big for int date type?
What is sql server programming?
What is a performance monitor?