Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and explain them
briefly.
- 3 Answers
- 11815 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
What is blind sql injection?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Why is nosql good?
what are the differences between char and varchar? : Sql dba
What are triggers in sql?
what is oltp (online transaction processing)? : Sql dba
what are the different type of sql's statements ? : Sql dba
What is sqlcontext?
What is trigger and types?
What is sql*loader and what is it used for?
How many types of indexes are there in sql?
Explain spool.
What is an oracle stored procedure?
Mention what does plv msg allows you to do?
Does inner join return duplicate rows?
