In sql joins are 3 types 1.Inner join 2.Outer join a)left outer join b)

What are joins..how many types of joins are there?

Question Posted / niranjan.b

Answer Posted / niranjan.b

In sql joins are 3 types
1.Inner join
2.Outer join
a)left outer join
b)right outer join
c)full outer join
3.Cross join

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the original export and import utilities?

1261

How to filter out duplications in the returning rows using oracle?

1068

What would you do with an in-doubt distributed transaction?

2049

How to select all columns of all rows from a table in oracle?

1104

Why do we use coalesce function in oracle?

1169

What is the difference between a user and a schema in oracle?

1082

Difference between inner join vs where ?

1096

What is the usage of synonyms?

1219

What is recovery manager in Oracle?

1112

What are temporal data types in oracle?

1171

How to loop through a cursor variable?

1128

Explain an exception and its types?

1141

Explain enable novalidate constraint.

1132

What are the set operators union, union all, minus & intersect meant to do?

1032

What is a Garbage Collection? and what is full recursive Garbage collection?

2957