Interested to Buy Any Domain ? << Click Here >> for more details...
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
What do you understand by coalesce in sql server?
How to create function with parameter in sql server?
What is a cube? : sql server analysis services, ssas
Can group by be used without aggregate functions?
Do you know sql server 2008 introduces automatic auditing?
How to count rows with the count(*) function in ms sql server?
How to delete existing rows in a table?
mention different types of relationships in the dbms?
what is the system function to get the current user's user id? : Sql server database administration
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Define magic tables in sql server?
What are the disadvantages of merge replication?
What languages bi uses to achieve the goal?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What are the advantages of using stored procedures in sql server?
