What is meant by Join? What are the different types of
Joins available? Explain.
Answer Posted / dinesh kumar
Joins -- Getting related data from more than one table.
Type:
Inner JOin --Equi Join -- Non Equi join
Outer JOin --LEft Join -- Right Join -- Full Outer JOin
CRoss Join
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is view? : Sql dba
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
what is 'mysqlshow'? : Sql dba
Define overloaded procedure?
Can we use rowid as primary key?
What is pl sql package?
How can you load multi line records? : aql loader
what is a trigger? : Sql dba
Explain constraints in sql?
what is offset-fetch filter in tsql? : Transact sql
What does the sign mean in sql?
What is procedure and function in sql?
What is difference between stored function and application function?
what is auto increment? : Sql dba
Difference between truncate, delete and drop commands?