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
- 17605 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
How exception handling is done in advance pl/sql?
What is auto increment?
What does the sign mean in sql?
Can we call a function containing dml statements in a select query?
What is normalization in a database?
How to select 10 records from a table?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Is it possible for a table to have more than one foreign key?
Is and as keyword in pl sql?
How does sql profiler work?
What are the basic sql commands?
Mention what are the benefits of pl/sql packages?
Is not null in sql?
define data blocks ? : Sql dba
Explain some predefined exceptions.
