Interested to Buy Any Domain ? << Click Here >> for more details...
Types of joins ?
- 11 Answers
- 24053 Views
- Polaris, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / khaleek
There are only three type of joins
1) Equi Join
2) Non Equi Join
3) Cartesian Product or Cross Join.
Further Equi Join and Non Equi join can be divided into
following categories.
1) Inner Join
2) Outer Join
3) Self Join
Again Outer can be divide into following categories.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join
For detail please see at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>
| Is This Answer Correct ? | 0 Yes | 1 No |
How many unique keys can a table have?
What are the sql aggregate functions?
How do I clear the screen in sql plus?
How is sql used in oracle?
how to decrement dates by 1 in mysql? : Sql dba
what is 'mysqlcheck'? : Sql dba
What company owns postgresql?
What are the main features of cursor?
What is full form of rtm?
Are sql database names case sensitive?
how to insert the records in particular position
Can we use views in stored procedure?
-
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)
