What is meant by Join? What are the different types of
Joins available? Explain.
- 5 Answers
- 16124 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 we use loop in sql?
How does postgresql compare to "nosql"?
Do prepared statements prevent sql injection?
How subquery works in sql?
What is having clause in sql?
Can unique keys be null?
What is the difference between left join and right join?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Why do we need pl sql?
What is sql lookup?
Show code of a cursor for loop.
What are the different types of functions in sql?
Can we delete column in sql?
What are the ddl commands?
Explain exception handling in pl/sql?
