Joins are the methods used to access related data from one or more tables

What is a join?Explain the different types of joins?

Question Posted / pravin

6 Answers
33944 Views
Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS, I also Faced
E-Mail Answers

Answer Posted / pravin

Joins are the methods used to access related data from one
or more tables. there are five types of join
1. Inner Join
2. Outer Join
3. Self Join
4. Mix Join
5. Exception Join

Is This Answer Correct ?

12 Yes

18 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to display Row Number with Records in Oracle SQL Plus?

1043

What are the topics in pl sql?

969

What is the least restrictive isolation level? : Transact sql

1063

what are all different types of collation sensitivity? : Sql dba

980

write an sql query to find names of employee start with 'a'? : Sql dba

1023

Is sql workbench free?

991

What packages are available to pl/sql developers?

1044

What is benefit of creating memory optimized table?

970

Can dml statements be used in pl/sql?

1073

What is pl sql script?

1026

How to use sql*plus built-in timers?

1193

what tools available for managing mysql server? : Sql dba

1077

what is primary key? : Sql dba

1023

what is a record in a database ? : Sql dba

1060

Can a key be both primary and foreign?

991