What is a join?Explain the different types of joins?
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
Difference between truncate, delete and drop commands?
Explain the insert into statements in sql?
What is pl sql variable?
What is function and procedure in pl sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Why do we use function in pl sql?
what is 'mysqlshow'? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
Can we use views in stored procedure?
What are the different types of joins in sql?
Do prepared statements prevent sql injection?
What is a natural join sql?
What is the use of triggers?
How to select unique records from a table?
What is sql select statement?