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 some examples of schemas?

How to list all user names in a database?

Explain identity in sql server?

which one will take 1st priority in case of insert statement and select statement???

What is named calculation? : sql server analysis services, ssas

What is clustered index

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

What is transaction server distributed transaction?

what stored procedure can you use to display the current processes? : Sql server administration

Write a sql query to delete duplicate records from a table called table1

Is sql server 2016 free?

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

For more SQL Server Interview Questions Click Here