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 Right Outer Join?

Question Posted / g.ramesh

Answers were Sorted based on User's Feedback



What is Right Outer Join?..

Answer / g.ramesh

It produce Result Set Which contains matched rows and right
table unmatched rows.

Is This Answer Correct ?    6 Yes 2 No

What is Right Outer Join?..

Answer / ram

select empno,ename,sal,e.deptno,dname from emp e right outer
join dept d where e.deptno=d.deptno

in abvoe query we use emp and dept table with right outer join
which produce output all records from dept table and
matched records from emp table

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to use subqueries with the in operators in ms sql server?

0 Answers  

Can you give an example of Stored Procedure?

4 Answers   Wipro,

Explain Normalization and DE normalization

0 Answers   iNautix,

What is advantage data architect?

0 Answers  

Explain triggers?

0 Answers  

What is user-defined function?

0 Answers  

When you should use a low fill factor?

0 Answers  

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,

What is the purpose of the model database?

0 Answers  

In which year relase the 7.0& 2000 & 2005?

1 Answers  

What are examples of triggers?

0 Answers  

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

For more SQL Server Interview Questions Click Here
Categories