What is meant by Join? What are the different types of
Joins available? Explain.
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
Which operator is used in query for pattern matching?
Why query optimization is needed?
Are dml statements autocommit?
Compare sql & pl/sql
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is percent sign in sql?
What is trigger in sql? Explain
What is implicit cursor in pl sql?
what are the advantages of sql ? : Sql dba
What is the sql case statement?
What is raw datatype in sql?
what is the functionality of the function htmlentities? : Sql dba
what is the difference between myisam static and myisam dynamic? : Sql dba
when is the use of update_statistics command? : Sql dba
What are the topics in pl sql?