What is meant by Join? What are the different types of
Joins available? Explain.
Answer Posted / mahesh
joins are used to relate two tables and display the result..
Types of join
1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Which query operators in sql is used for pattern matching?
Define commit, rollback and savepoint?
Can we join two tables without common column?
Is sql considered coding?
What does the hierarchical profiler does?
What are the advantages of indexing?
Is sql similar to python?
what is 'mysqladmin' in mysql? : Sql dba
Is sql a case sensitive language?
How to run pl/sql statements in sql*plus?
What is package in pl sql with an examples?
What are the 3 types of behavioral triggers?
What do you mean by rowid?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What is break?