Follow Our FB Page << CircleMedia.in >> 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 @ mak2786@gmail.com

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  






Categories