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 the main difference between after trigger and instead trigger.

2 Answers  

what type of indexes physically sort data?

3 Answers  

How do you create an execution plan?

0 Answers  

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

What is difference between joins and subqueries?

0 Answers  

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

What are database states in ms sql server?

0 Answers  

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories