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

explain different types of joins? : Sql server database administration

What do you mean by tablesample?

What is the difference between cube operator and rollup operator? : SQL Server Architecture

Can we call future method from trigger?

What specific conditions database should meet, before you can bulk copy data into it using bcp?

what exactly sql injuction.how to overcome.....

What should we do to copy the tables, schema and views from one SQL Server to another?

What type of locking occurs during the snapshot generation? : sql server replication

Explain cdc and sql injection?

What is the contrast between sql and mysql?

How can sql server instances be hidden?

What are different types of views?

For more SQL Server Interview Questions Click Here