Interested to Buy Any Domain ? << Click Here >> for more details...
what is the advantage of left outer join?
- 2 Answers
- 13984 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 |
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table??
Is microsoft sql same as mysql?
How to execute mysql query in php?
What is difference between oracle and mysql?
How to represent ENUMs and SETs internally?
What is MySQL Stored Procedure?
How to enter boolean values in sql statements?
Is mysql query case sensitive?
How to use like conditions?
How To see all the tables from a database of mysql server.
What is blob storage?
-
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)
