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
- 10350 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
Explain how many normalization forms?
whats new about truncate in sql server 2008?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is clustered index
What command must you use to include the not null constraint after a table has already been created?
Explain unique key in sql server?
What is the dbcc command and why is it used?
Explain about the command-line tool SQLCMD?
List the different index configurations possible for a table?
What are the new security features added in sql server 2012? : sql server security
What are page splits? : SQL Server Architecture
Mention the different types of replication in sql server.
List out the difference between union and union all in sql server?
How to concatenate two character strings together?
What is normalization and what are the advantages of it?
