1)Self Join 2)Equi join (or)Inner Join 2.1)Non-equi Join 3)Outer Join

what are the different 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 ?

14 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain some predefined exceptions.

1043

what are all the common sql function? : Sql dba

1062

What is the non-clustered index in sql?

1066

What is acid property in a database?

1036

What is pivot query?

1082

What is prepared statement in sql?

1056

What is the difference among union, minus and intersect?

1004

What is database white box testing and black box testing?

1117

What is java sql driver?

1129

What is a sql select statement?

1042

What is the default isolation level in sql server? : Transact sql

1033

What is a call statement? Explain with an example.

1018

What is the difference between nested table and varray?

1013

What is pessimistic concurrency control? : Transact sql

1094

What is sql trigger example?

1071