1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

what is JOIN? Give example & types of join?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is JOIN? Give example & types of join?..

Answer / santhi mundru

Merging two or three as a single table is called "join"
Types:
Inner Join
Outer Join
right outer join
left outer join
self join.

Is This Answer Correct ?    0 Yes 0 No

what is JOIN? Give example & types of join?..

Answer / sahib

the relationship between two or more tables
Types of join:
Three Types of joning

Is This Answer Correct ?    3 Yes 10 No

what is JOIN? Give example & types of join?..

Answer / santosh

joins are three types
equity join
natural join
conditional joins
these joins use to create conection b\w thie attributes

Is This Answer Correct ?    18 Yes 39 No

what is JOIN? Give example & types of join?..

Answer / sriram

outer join

Is This Answer Correct ?    12 Yes 35 No

Post New Answer

More MySQL Interview Questions

How to run 'mysql' commands from a batch file?

0 Answers  

What are the differences between char and nchar?

0 Answers  

What is mysql good for?

0 Answers  

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

0 Answers  

How set mysql root password?

0 Answers  




How to use sum function in where clause in mysql?

0 Answers  

What is mysql vs sql?

0 Answers  

Can mysql function return a table?

0 Answers  

What is the maximum number of records in mysql table?

0 Answers  

How to concatenate two character strings?

0 Answers  

What is heap table?

0 Answers  

What are different types of queries?

0 Answers  

For more MySQL Interview Questions Click Here
Categories