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 / pratap

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

Answer Posted / pratap

Joins are the methods used to access related data from one
or more tables. there are five types of join
1. Equi join(i.e. Inner join)
2. self join
3. left join
4. right join
5. outer join

Is This Answer Correct ?

17 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is sql? : Sql dba

1030

What is sql*loader and what is it used for? : aql loader

1177

What is the difference between local variables and global variables?

1126

what are the different functions in sorting an array? : Sql dba

1027

What is the difference between nested table and varray?

1007

Is sql pronounced sequel or sql?

1273

What is difference between inner join and self join?

1088

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

1048

How many types of triggers are there in pl sql?

1069

What is the maximum database size for sql express?

1030

What does count (*) do in sql?

1017

How would you convert date into julian date format?

1006

What are different types of indexes?

1012

what is a stored procedure? : Sql dba

1138

What is mutating error in pl sql?

1023