What are the type of joins? When do we use Outer and Self joins?
- 3 Answers
- 9590 Views
- I also Faced
- E-Mail Answers
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 |
what protocol both networks use? : Sql server database administration
What command do we use to rename a database?
What is difference between foreign key and unique key?
What is Command line parameters in PLSQL.?
What are different types of join?
What is implicit cursors?
How to resolve the orphan use problem? : sql server security
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is the purpose of floor function?
where the connection string store in the database
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
How many types of schemas are there?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
