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 |
Do you know what are various aggregate functions that are available?
What are the differences between user defined functions and stored procedures?
What are the different types of replication you can set up in sql server?
What happens if null values are involved in comparison operations?
What are the types of indexes available with SQL Server?
What is the purpose of floor function?
What is extent? Types of extents?
How does recursive cte works in sql server?
What is scalar user-defined function?
What is live lock and deadlock? what is Lock escalation?
Explain log shipping?
What is the maximum size of sql server database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)