Answer Posted / 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 |
Post New Answer View All Answers
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Which autogrowth database setting is good?
Can you explain about buffer cash and log cache in sql server?
According to you what goes into making the best database administrator? : sql server database administration
What are the dmvs? : sql server database administration
Difference between group by clause and having clause in SQL?
What is view in sql?
How to choose all records from the table?
Call by value and call by reference in procedure and function, with NOCOPY.
What are the new features of sql server 2008 r2 reporting service?
What is the order by used for?
What is named query? : sql server analysis services, ssas
What is coalesce in sql server?
What is analysis service repository?
What is collation sensitivity? Explain different types.