what is JOIN? Give example & types of join?
Answers were Sorted based on User's Feedback
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 |
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 |
Can you rename a database in mysql?
What is pdo mysql?
Is mysql a programming language?
How do I view tables in mysql workbench?
maximum database size of mysql database
Which is better sqlite or mysql?
what is the difference between between and in operators in mysql?
State the differences between mongodb and mysql.
when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field
What is a text delimiter?
Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows
How do you start and stop MySQL on Windows?