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 |
How do I get sql certification?
how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query
How many sql are there?
What is normalisation in sql?
Why stored procedure is faster than query?
what is the difference between undefined value and null value? : Sql dba
What is clause in sql?
Is like operator in sql case sensitive?
Can we group by two columns in sql?
What is restrict in sql?
What is difference between cursor and trigger?
What is Difference between StoredProcedure and function?