What is a left join?
- 1 Answers
- 1049 Views
- I also Faced
- E-Mail Answers
Answer / Anusha Sachan
A LEFT JOIN retrieves records from both tables in the join operation, but returns all records from the table on the left and matching records (if any) from the table on the right. If there are no matches for the right table, NULL values will be returned for those columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to return more than one value from a function?
What is data control language?
If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
How to connect a sql*plus session to an oracle server?
What is the difference among union, minus and intersect?
How do I make sql search faster?
what is explain plan?
What are the differences between Database Trigger and Integrity constraints ?
How to rename a column in the output of sql query?
What is a system versioned table?
what are the differences between char and varchar? : Sql dba
What is the difference between pl and sql?
-
Oracle (3253) - 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)
