What are the different types of joins and explain them
briefly.
- 3 Answers
- 11092 Views
- I also Faced
- E-Mail Answers
Answer Posted / rahul koshti
There are 2 main type of joins :
Equijoin : Join N number of tables for equality =.
Non-Equijoin : Join N number of tables for other than
equality such as <>,<,>,IN,BETWEEN etc.
Technically there are total 3 different types of joins:
Cross Join: When join condition is missing then all rows
from one table gets joined with all rows from other table..
Inner Join: If a row has a NULL value in any one of the
columna of join conditin then that row will not fetched.
Outer Join: Even if the NULL values are present in any
columns of join condition that record will get fetched.
There are again 3 types of outer joins: Left, Right, Full.
Self Join : A table is joined with self.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Which normal form is best?
what are the features and advantages of object-oriented programming? : Sql dba
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Why we use joins in sql?
what is the bond code in materialized view?
What is normalisation and its types?
What is character functions?
Which tcp/ip port does sql server run?
What is memory optimized?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
State few characteristics of pl/sql?
what are the type of locks ? : Sql dba
what are the advantages of using stored procedures? : Sql dba
Why do we use subquery?
What is oracle and pl sql?
