Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What is Left Outer Join?

Answers were Sorted based on User's Feedback

What is Left Outer Join?..

Answer / g.ramesh

It produce Result Set which contains matched rows and left
table unmatched rows.

Is This Answer Correct ?    3 Yes 2 No

What is Left Outer Join?..

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

Post New Answer

More SQL Server Interview Questions

What are the authentication modes in sql server? How can it be changed?

0 Answers  

What are the purposes and advantages stored procedure?

0 Answers  

Explain filestream storage of sql server 2008?

0 Answers  

How many instances per computer are there in sql server 2000?

0 Answers  

Explain the properties of sub-query in sql server?

0 Answers  

What is dbcc? Give few examples.

0 Answers  

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @

35 Answers   Oracle, Scend, TechInfini,

What is RMS migrations?

0 Answers   Satyam,

Can we add an identity column to decimal datatype?

0 Answers  

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

How to find the list of fixed hard drive and free space on server?

0 Answers