What is Left Outer Join?
Answers were Sorted based on User's Feedback
Answer / g.ramesh
It produce Result Set which contains matched rows and left
table unmatched rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / prasanna
The result set of a left outer join includes all the rows
from the left table specified in the LEFT OUTER clause, not
just the ones in which the joined columns match. When a row
in the left table has no matching rows in the right table,
the associated result set row contains null values for all
select list columns coming from the right table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Write a SQL query to delete a table?
What is statement level trigger?
What are the advantages to use stored procedures?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
How to create an index on an existing table in ms sql server?
Explain sql server service broker?
Is it important for a database administrator to understand the operating system and file access?
How many types of the database links?
What is the difference between functions and scalar functions?
Can binary strings be converted into numeric or float data types?
What is multilevel indexing?
what is an extended stored procedure? : Sql server database administration
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)