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

Write a SQL query to delete a table?

0 Answers   Amdocs,

What is statement level trigger?

0 Answers  

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

How to create an index on an existing table in ms sql server?

0 Answers  

Explain sql server service broker?

0 Answers  

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

How many types of the database links?

0 Answers   MCN Solutions,

What is the difference between functions and scalar functions?

0 Answers   EXL,

Can binary strings be converted into numeric or float data types?

0 Answers  

What is multilevel indexing?

0 Answers  

what is an extended stored procedure? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories