What are different types of joins ?
Answers were Sorted based on User's Feedback
Answer / amit das
1.Equi join
2.Natural Join
3.cartegian/cross/non-equi join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mathan kumar
Two Type of Joins are there
1) Inner Join
2) Outer Join
In Inner join has 3 types they are as follows
a)Equi join
b)Cross Join
c)Natural Join
In Outer join has 3 types they are as follows
a)Left Outer Join
b)Right Outer Join
c)Full Outer Join
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sreekanth
Basically there are 5 types of joins, they are
1.Equi join
2.Non-equi join
3.cartegian join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / t.rajesh gupta
Different types of joins are 1.self join, 2. Equi join, 3.
non-equi join 4. cross join
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / amar misra
1-Inner Join
2-Outer Join
3-Left Join
4-Right Join
5-Self Join
Is This Answer Correct ? | 0 Yes | 0 No |
Mention what are different methods to trace the pl/sql code?
Is pl sql better than sql?
What is auto increment?
How to convert ms-excel file to oracle table?
How many sql commands are there?
how to rename an existing table in mysql? : Sql dba
How many tables can you join in sql?
Is clustered index a primary key?
What is Difference Between delete and Truncate?
What is dense_rank in sql?
package specification-3 procedures package body-4 procedures how can i write for other procedure in package body
What is union and union all keyword in sql and what are their differences?