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

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

Question Posted / prabir4prabir


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

What is optimization and its types?

0 Answers  

Write a query to get all details of employee who has maximum salary from employee table

8 Answers   AON, Genpact,

What are the different types of queries?

1 Answers  

what are batch in sql server?

2 Answers   Satyam,

What are built in functions?

0 Answers  

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

logshipping is Any difference 2000 and 2005?

2 Answers  

How make remote connection in database?

1 Answers  

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

How to populate a table in sql server?

0 Answers  

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories