what is JOIN? Give example & types of join?
Answer Posted / ammu
joins are nothing but a condition that combines two or more table resulting with an single table
types of joins :
--> inner join
*equi join
*cross join
--> outer join
*left outer join
*right outer join
*full outer join
--> self join
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many triggers are possible in mysql?
What is mysql community edition?
What is the difference between the primary and unique key in mysql?
can you tell what are the different set operations available in mysql? : Mysql dba
Where is mysql used?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
What are Heap tables?
What does mysqli_fetch_assoc do?
How do you know the version of your mysql server?
What is indexing in mysql?
What is the datatype for password in mysql?
How do I create a schema in mysql?
Is mysql a free database?
What is the storage engine for mysql?
Can mysql scale horizontally?