1) SELF JOIN 2) EQUI JOIN(OR) INNER JOIN 2.1) NON-EQUI JOIN 3)OUTER JO

Types of joins ?

Question Posted / a.jyothsna

Answer Posted / 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 ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

tell me about various levels of constraint. : Sql dba

1035

Why functions are used in sql?

990

what is the difference between nested subquery and correlated subquery?

1053

what is heap table? : Sql dba

1105

Name the different types of indexes in sql and define them.

1150

what are the differences between require and include, include_once and require_once? : Sql dba

1020

What is primary key and unique key?

1120

How to run pl/sql statements in sql*plus?

1079

What is recursive stored procedure?

1099

What is the least restrictive isolation level? : Transact sql

1066

Can we use loop in sql?

967

Why is sharding used?

993

How do you optimize a stored procedure query?

998

How does stored procedure reduce network traffic?

1007

Does execute immediate commit?

1217