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...


If we use where clause in the left outer join then how the
query would behave/act?



If we use where clause in the left outer join then how the query would behave/act?..

Answer / prabir4prabir

It will act as a inner join.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Do you know what guidelines should be followed to help minimize deadlocks?

0 Answers  


create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,


How many types of triggers in sql server?

0 Answers  


What are 3 ways to get a count of the number of records in a table?

0 Answers  


How can you find out how many rows returned in a cursor?

0 Answers  


Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,


What is the difference between getdate and sysdatetime?

0 Answers  


what are the Prerequisites for Replication?

1 Answers   IBM,


How to find which stored procedure is currently running in sql server?

0 Answers  


What are the steps you should follow to start sql server in single-user mode?

0 Answers  


What is difference between equi join and inner join?

0 Answers  


Explain the properties of subqueries in sql server?

0 Answers  


Categories