Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and explain them
briefly.
- 3 Answers
- 11635 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul koshti
There are 2 main type of joins :
Equijoin : Join N number of tables for equality =.
Non-Equijoin : Join N number of tables for other than
equality such as <>,<,>,IN,BETWEEN etc.
Technically there are total 3 different types of joins:
Cross Join: When join condition is missing then all rows
from one table gets joined with all rows from other table..
Inner Join: If a row has a NULL value in any one of the
columna of join conditin then that row will not fetched.
Outer Join: Even if the NULL values are present in any
columns of join condition that record will get fetched.
There are again 3 types of outer joins: Left, Right, Full.
Self Join : A table is joined with self.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How does sql*loader handles newline characters in a record? : aql loader
Name the different types of indexes in sql and define them.
What are the subsets of sql?
What are the most important ddl statements in sql?
what is data control language? : Sql dba
What is the difference between rollback and rollback to statements?
What is meant by temporal data?
Is join same as left join?
explain access control lists. : Sql dba
What is the difference between null value, zero, and blank space?
What is spool?
What is percent sign in sql?
What is the difference between sql and mysql?
What is sql query limit?
how would you get the current date in mysql? : Sql dba
