What is meant by Join? What are the different types of
Joins available? Explain.
- 5 Answers
- 15305 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Why coalesce is used in sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
define join and explain different type of joins? : Sql dba
List and explain the different types of join clauses supported in ansi-standard sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
what happens if null values are involved in expressions? : Sql dba
What are the three pl sql block types?
how to see the create table statement of an existing table? : Sql dba
What is a temporal data type?
When you have to use a default "rollback to" savepoint of plvlog?
What is a native sql query?
What is sql deadlock?
Which table is left in join?
What is a table in a database?
In pl/sql, what is bulk binding, and when/how would it help performance?
