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

what is the advantage of left outer join?

Question Posted / imran88r

Answers were Sorted based on User's Feedback



what is the advantage of left outer join?..

Answer / manish kumar

the left outer join can be used whih return all the rows
from the first table,even if there are no matchesin the
seond table

Is This Answer Correct ?    13 Yes 2 No

what is the advantage of left outer join?..

Answer / tanseer ahmed

left outer join return all matching record + all record of
first table, if there are no matching record then
display only firt table all record

Is This Answer Correct ?    7 Yes 1 No

Post New Answer

More MySQL Interview Questions

How to show table structure mysql?

1 Answers  

How to store binary data in mysql?

1 Answers  

Give the syntax of REVOKE commands?

1 Answers  

What is maximum size of a database in MySQL?

13 Answers   Bastioncoup, CIS, NM, V2 Solutions, Wipro,

Which is faster innodb or myisam?

1 Answers  

How do I start mysql server?

1 Answers  

What is ndb in mysql?

1 Answers  

What is user in mysql?

1 Answers  

What is the difference between char and varchar in mysql?

1 Answers  

In mysql, what is joins? Explain

1 Answers  

How do I create a stored procedure in mysql?

1 Answers  

maximum database size of mysql database

2 Answers  

For more MySQL Interview Questions Click Here
Categories