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 |
Why plvtab is considered as the easiest way to access the pl/sql table?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,
Which type of cursor is used to execute the dml statement?
How do I order columns in sql?
Give an example of any procedure.
5 Answers Accenture, iFlex, Wipro,
What are the most important ddl statements in sql?
What is where clause in sql?
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
check whether all the emp numbers are indeed unique.
What is rownum and rowid?
Can you call pl/sql package functions from within a fast formula?