Interested to Buy Any Domain ? << Click Here >> for more details...
What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
- 2 Answers
- 7991 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / sunil kumar
Inner join=>Inner join returns rows when there is at least
one match in both tables.
Outer Join=> Outer Join returns the set of all matching
records from both tables. Outer join doesn`t require each
record to be matched in both the tables.
Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.
Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.
| Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
What is mysql vs sql?
How to show certain selected rows with the value "pcds".
Tell us something about heap tables?
How can you change the name of any existing table by using the sql statement?
What does innodb stand for?
How can you calculate the sum of any column of a table?
explain GROUPBY & HAVING clause with examples.
How to do login in mysql with unix shell.
Is number a datatype in mysql?
Should I use pdo or mysqli?
What are the difference between mongodb and mysql?
What are ddl statements in mysql?
Can we rollback truncate in mysql?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
How do I create a schema in mysql?
