What are the type of joins? When do we use Outer and Self joins?
Answers were Sorted based on User's Feedback
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 |
Answer / shivanibehere
For the joins you can go for this link ----
http://www.databasejournal.com/features/oracle/article.php/3
527921
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shivanibehere
http://www.tomjewett.com/dbdesign/dbdesign.php?
page=jointypes.php&imgsize=medium
Is This Answer Correct ? | 0 Yes | 0 No |
Repair mdf file
how to take backup bcp out for a column in table in sql server?
Wht is SQL Injection Attack ?
What is db stored procedure?
Why we need a group by clause?
What is the difference between a clustered index and a non-clustered index?
Why is replication required on the sql server?
Explain indexing and what are the advantages of it?
Is it ok to shrink transaction log?
what is node in sql server?
2 Answers CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,
What is the syntax for encrypting a column in SQL Server?
How to find the second highest salary of an employee?