Types of joins ?

Question Posted / wgk

11 Answers
20134 Views
Polaris, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Types of joins ?..

Answer / khaleek

There are only three type of joins
1) Equi Join
2) Non Equi Join
3) Cartesian Product or Cross Join.

Further Equi Join and Non Equi join can be divided into
following categories.
1) Inner Join
2) Outer Join
3) Self Join

Again Outer can be divide into following categories.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join

For detail please see at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

What are the most important ddl statements in sql?

0 Answers

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers Satyam,

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers Tech Mahindra,

What are procedures used for?

0 Answers

What is the difference between an inner join and an outer join?

0 Answers

how would you enter characters as hex numbers? : Sql dba

0 Answers

How many types of index are there?

0 Answers

What is information schema in sql?