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

Explain user defined functions?

0 Answers  

What happens if null values are involved in datetime operations?

0 Answers  

What is function of ROLLUP ?

0 Answers   HCL,

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

What is forward - only cursors / read only cursor?

0 Answers  

What is a non clustered primary key?

0 Answers  

How to find out what is the default collation in a database?

0 Answers  

How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes

1 Answers   INDUS,

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

0 Answers  

What do you mean by sql server 2005 express management tools?

0 Answers  

What does null mean?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories