Interested to Buy Any Domain ? << Click Here >> for more details...
what is the advantage of left outer join?
- 2 Answers
- 13930 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is a tinyint in mysql?
What is required to create mysql database?
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
What can I do with mysql?
Explain % and _ inside like statement?
How do I start mysql from command line?
How to add a new column to an existing table in mysql?
Can a table have multiple primary keys?
What is database engine in mysql?
How we can get distinct columns values in mysql?
How many rows can mysql hold?
What language does mysql use?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
