Interested to Buy Any Domain ? << Click Here >> for more details...
What is Left Outer Join?
- 2 Answers
- 4483 Views
- I also Faced
- E-Mail Answers
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 |
Explain raiserror in sql server?
what is raid and what are different types of raid configurations? : Sql server database administration
diffrence between Cluster Index and non Cluster Index
How to configure and test odbc dsn settings?
How to get a list of columns in a view using the "sp_help" stored procedure?
Does partitioning improve performance?
What are points to remember while using the fillfactor argument?
What is after dml trigger?
Explain transaction server consistency?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What is normalization and denormalization in sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
-
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)
