What is a join?Explain the different types of joins?
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
Why self join is used in sql?
how to include comments in sql statements? : Sql dba
How to assign sql query results to pl sql variables?
what is clause? : Sql dba
Inline the values in PL/SQL, what does it mean.?
What is the full form of sql?
What are different types of functions in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Why partition by is used in sql?
How can we optimize a sql query?
Can we use insert statement in function?
What is embedded sql in db2?
When you have to use a default "rollback to" savepoint of plvlog?
What are the disadvantages of not performing database normalization?
What are tables and fields in the database?