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

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

More SQL Server Interview Questions

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

Can truncate be rolled back?

What is the purpose of optimization?

Diffrent types of function

What is the primary use of the model database?

What is sql server 2000 work load governor?

What is row_number () and partition by in sql server?

What is mean by candidate key?

Give an example of why you would want to denormalize a database

What is the difference between a view and a stored procedure?

select empid empname from employee What is the result for the about query?

How to copy the tables, schema and views from one sql server to another?

For more SQL Server Interview Questions Click Here