Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is Left Outer Join?

Question Posted / g.ramesh

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 is #temp and @table variable in SQL server?

0 Answers  

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

What is the user of Primary key?

0 Answers  

Explain what is cte (common table expression)?

0 Answers  

How can you ensure that the database and sql server based application perform well?

0 Answers  

What are different backups available in sql server?

0 Answers  

What is the difference between osql and query analyzer?

0 Answers  

Explain cross join or cartesian product in sql?

0 Answers  

What happens if the update subquery returns no rows in ms sql server?

0 Answers  

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

For more SQL Server Interview Questions Click Here
Categories