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 is SQL Profiler and the use of it?

What are the types of subquery?

How to use column default values in insert statements in ms sql server?

Explain what are the restrictions while creating batches in sql server?

How do you find the error, how can you know the number of rows effected by last SQL statement?

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

Are connections to sql server encrypted?

What is faster join or union?

Explain external key management in sql server 2008

Can a trigger be created on a view?

What are the different types of triggers in SQL SERVER?

What is a ddl statement?

For more SQL Server Interview Questions Click Here