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

1 Answers
4114 Views
I also Faced
E-Mail Answers

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 normalization of database? What are its benefits?

0 Answers

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers

Can we move Resource database from one path to another? If yes,How can we?

1 Answers Wipro,

How to find the second highest salary of an employee?

0 Answers

What is the bookmark lookup and rid lookup?

0 Answers

What do you mean by data manipulation language?

0 Answers

How to find out the list schema name and table name for the database?

0 Answers

Tell me about builtinadministrator?