what are the different types of joins?
Answers were Sorted based on User's Feedback
Answer / a.jyothsna
1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / desiraju venkata subramanya ka
types of joins
• outer join
• left join
• right join
• equi-join
• non-equi-join
• selfJoin
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / prakash
Proprietary Joins
----------------
EquiJoin
Non EquiJoin
Self Join
outer join
Compliant Joins
---------------
Cross Join
Natural Joins
Full or two sided outer joins
Arbitrary Joins
Is This Answer Correct ? | 0 Yes | 1 No |
What is sql in oracle?
What is primary key in db?
What are procedures used for?
Name some usages of database trigger?
What are sql procedures?
define sql insert statement ? : Sql dba
What is dbo in sql?
How do you pronounce sql?
what eliminate duplicate without using roenum and not
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
Is it possible to sort a column using a column alias?
What is the use of <> sql?