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
- 17580 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
Can a varchar be a primary key?
How bulk collect improves performance?
What is sql in java?
What is the use of triggers?
Can we delete column in sql?
What is the difference between alter trigger and drop trigger statements?
Is sql better than excel?
How you improve the performance of sql*loader? : aql loader
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is difference between function and trigger?
what is a materialized view? : Sql dba
What found sql?
What are sql triggers used for?
What is assignment operator in pl sql?
What is the best free sql database?
