Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by Join? What are the different types of
Joins available? Explain.
- 5 Answers
- 17381 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
What does the argument [or replace] do?
What is keys and its types?
Can we insert data in view?
what are the advantages and disadvantages of views in a database? : Sql dba
How we can update the view?
What is input buffer in sql*plus?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
what are the differences between char and nchar? : Sql dba
What is the need of a partition key?
What is sql partition function?
What is the difference between partitioning and sharding?
What are keys in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
How is debugging done?
