what is JOIN? Give example & types of join?
Answer Posted / vijay
Join:-
Join are used to retrieve data from more than one
table simultancously .
Types of join are:-
1.Outer join
*--Right Outer join
*--Left Outer join
*--Full Outer join
2.Multiple join
3.self join
4.Inner join
5.cross join
Is This Answer Correct ? | 18 Yes | 6 No |
Post New Answer View All Answers
How MySQL Optimizes DISTINCT?
How to shutdown mysql server?
Can you shard mysql?
What are the types of index?
Write a query to count the number of rows of a table in mysql.
How many rows can a mysql table hold?
How do I restore a mysql database?
What is difference between function and procedure in mysql?
How database are managed?
Is foreign key indexed mysql?
How to find the unique values if the value in the column is repeated?
How to include numeric values in sql statements?
How many groups of data types?
How do I create a stored procedure in mysql?
How to set the time zone for MySQL to particular country time?