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
Is mariadb better than mysql?
How to decrement dates by 1 in mysql?
What are date and time functions in mysql?
How do I set user privileges in mysql?
What is the purpose of -> in the mysql terminal?
How we get sum of column.
How do you create a schema?
What is the use of concat() in mysql?
Which datatype is used for email in mysql?
How to drop an existing table in mysql?
How will show all records containing the name "sonia" and the phone number '9876543210'
What causes mysql too many connections?
What is the latest version of mysql?
What is data types in mysql?
What is the use of pdo?