equi join , non-equi join, self join, outer join, cross join.

What are the different types of joins and explain them
briefly.

Question Posted / hindol

Answer Posted / hindol

equi join ,
non-equi join,
self join,
outer join,
cross join.

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why stored procedure is faster than query?

1035

Differentiate between sga and pga.

1142

How do you delete a table?

1053

Explain foreign key in sql?

1006

What are sql built in functions?

919

What is a join?

1046

What is trigger and stored procedure in sql?

1016

What is query syntax?

952

Can a key be both primary and foreign?

979

What is a recursive join sql?

1050

What is dialect in sql?

924

Can we use joins in subquery?

1141

What are aggregate and scalar functions?

1002

What is duration in sql profiler trace?

1063

what are string data types? : Sql dba

1023