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
33633 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

Is json a nosql?

914

How do you declare a variable in pl sql?

965

is mysql query is case sensitive? : Sql dba

1030

how can we repair a mysql table? : Sql dba

914

what is an extent ? : Sql dba

1018

Is postgresql a nosql database?

1074

What is difference between inner join and self join?

1028

How do I delete a trigger?

912

Can there be more than one function with a similar name in a pl/sql block?

925

how to shut down the server with 'mysqladmin'? : Sql dba

955

how do you tune the slow running queries in oracle db , explain the methodology

2058

Why partition by is used in sql?

970

What is delete command in sql?

1051

how can we destroy the cookie? : Sql dba

959

What are the set operators in sql?

1028