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
- 17117 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
Explain dml and ddl?
Is the primary key an index?
What is rtm stands for?
What is raid? How does it help storage of databases?
What is difference between sql and mysql?
What is a data definition language?
What is the maximum rows in csv?
how can we find the number of rows in a table using mysql? : Sql dba
What is autocommit sql?
Is full outer join same as cross join?
What is difference between my sql and sql?
What are the query optimization techniques?
What is forward declaration in pl sql?
What is the size of partition table?
who introduced sql?
