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

How does pl sql work?

909

What is primary and foreign key?

1014

What is a data manipulation language?

961

Why is sql important?

1021

How do I find duplicates in sql?

873

what is the difference between nested subquery and correlated subquery?

980

How do I clear the screen in sql plus?

978

how to check server status with 'mysqladmin'? : Sql dba

1009

What is the difference between delete and truncate commands?

968

How to read xml file in oracle pl sql?

859

Why do we use view in sql?

905

What does cursor do in sql?

968

Which is faster union or join?

898

What are the three forms of normalization?

992

Can we join same table in sql?

958