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

Define full outer join in sql server joins?

0 Answers  

How to find out the list schema name and table name for the database?

0 Answers  

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

What is onf in normalization form?

0 Answers  

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

Explain collation?

0 Answers  

explain different types of jions with examples briefly?

1 Answers   Zensar,

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

what is the output for this query select * from employee where 1=1;

4 Answers  

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

Explain what is lock escalation?

0 Answers  

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

For more SQL Server Interview Questions Click Here
Categories