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
How does a covering index work?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is the size of partition table?
What is the starting oracle error number? What is meant by forward declaration in functions?
What are the parts of a basic sql query?
What are the different type of joins in sql?
What is set serveroutput on in pl sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is denormalization in a database?
What is data type in sql?
Is sql open source?
What is sql in java?
What is indexing in sql and its types?
How do you write a subquery?
What is sql and also describe types of sql statements?