What is a join?Explain the different types of joins?
Answer Posted / pravin
Joins are the methods used to access related data from one
or more tables. there are five types of join
1. Inner Join
2. Outer Join
3. Self Join
4. Mix Join
5. Exception Join
| Is This Answer Correct ? | 12 Yes | 18 No |
Post New Answer View All Answers
How does sql profiler work?
What are the two parts of design view?
How to add a column ‘salary’ to a table employee_details?
what is dbms? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
How many types of privileges are available in sql?
define data blocks ? : Sql dba
Why cross join is used?
What is difference between sql function and stored procedure?
What is the difference between having clause and where clause?
Explain the uses of database trigger.
What are the different operators available in sql?
what is 'mysqlcheck'? : Sql dba
Is sql an operating system?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?