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
Why are function needed?
What is triggers and how it can be used in mysql?
Which datatype is used for email in mysql?
What are the different types of triggers in mysql?
Why is mysql popular?
How to display top 10 rows in mysql?
How to delete a table.
Can not connect to mysql server 10060?
What are the similarities between a function and a procedure?
What is a text delimiter?
How do I set user privileges in mysql?
How does select query work?
Which statement is used in a select query for partial matching?
What is a transaction? Describe mysql transaction properties.
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?