2 types 1)inner join , 2)outer join a)left outer b)right outer c

Types of joins ?

Question Posted / vinodkumar.r

Answer Posted / vinodkumar.r

2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Differentiate between syntax and runtime errors.

1239

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1123

Difference between global and parameter variables?

2012

Does inner join return duplicate rows?

1039

What is pl sql package?

1071

What is the unique index?

1107

What is the command used to fetch first 5 characters of the string?

1463

What is full join in sql?

1033

What are the benefits of triggers?

1217

Is pl sql and postgresql same?

1179

Can 2 queries be executed simultaneously in a distributed database system?

1192

What is data definition language?

1135

Differentiate pl/sql and sql?

1130

what is isam? : Sql dba

1065

What does pragma mean?

1130