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

Describe sql comments?

1116

What is rank dense_rank and partition in sql?

1087

How do I add a primary key to a table?

1085

What are sql data types?

1072

What is a parameter query?

1144

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

999

Is join an inner join?

1026

How do you identify a primary key?

1115

How many times can we commit in a loop?

1067

What are all different types of collation sensitivity?

1077

What will you get by the cursor attribute sql%found?

1009

Is mariadb a nosql database?

1102

What is package in pl sql?

1086

What is difference between table and view?

1139

Show the two pl/sql cursor exceptions.

1263