Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of joins and explain them
briefly.
- 3 Answers
- 11798 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 the cause of mutating table error and how can we solve it?
What are functions in sql?
What is pl sql and why it is used for?
What are the different types of dbmss?
What is the usage of nvl function?
How to call a javascript function from pl sql?
Do we need to rebuild index after truncate?
Is sql a dbms?
What is difference sql and mysql?
What is the difference between sql and mysql?
Does truncate need commit?
What is the difference between Union and Union all. Which is faster.
What is sqlservr exe?
What are the advantages of sql?
what is a foreign key ? : Sql dba
