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
34228 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 do you concatenate in sql?

1086

What can sql server reporting services do?

1162

how can you see all indexes defined for a table? : Sql dba

1048

What is the size of partition table?

1088

What are commit, rollback, and savepoint?

1045

what are the advantages a stored procedure? : Sql dba

1018

Which join is default?

1012

what is 'mysqldump'? : Sql dba

1165

What is the use of desc in sql?

1017

What are sql indexes?

1045

Can we insert data in view?

1007

Compare sql & pl/sql

1209

Does google use sql?

1003

What is sql query limit?

1016

Can we rename a column in the output of sql query?

1038