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

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

What do you mean by authentication modes in sql server?

0 Answers  

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

What are transactions and its controls?

0 Answers  

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

What is database dimension? : sql server analysis services, ssas

0 Answers  

How many levels of sp nesting is possible?

0 Answers  

What is implicit mode in sql server?

0 Answers  

What is change tracking in sql server?

0 Answers  

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

What is meant by indexing?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories