What is meant by Join? What are the different types of
Joins available? Explain.
- 5 Answers
- 17747 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / kilari hemadri
Joins is used to relate two tables and display the result..
types of joins are
inner join
left join
right join
full join
cross join
inner join : It is used to display the common values in
both the tables based on the condition given.
left join : Left join displays all the contents of left
table and dislays the right table contents that are present
in left table.
right join : it is contraversy to left join
full join : it is combination of both left and right joins.
cross join: it takes one row of left table and matches with
all the rows in the right table.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what are the advantages of sql ? : Sql dba
Do we need to rebuild index after truncate?
Can delete statement be rollbacked?
What is the current version of postgresql?
what is sql server agent? : Sql dba
How do I remove duplicates in two columns?
what are aggregate and scalar functions? : Sql dba
what is collation? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Can we rollback truncate?
what is dbms? : Sql dba
Is primary key always clustered index?
what is schema? : Sql dba
What is the current version of sql?
