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



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

Explain few examples of RDBMS?

0 Answers   Wipro,


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  


What is inline variable assignment?

0 Answers  


What stored by the master? : sql server database administration

0 Answers  


what are different types of raid configurations? : Sql server database administration

0 Answers  






What are the requirements to use odbc connections in php scripts?

0 Answers  


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


What are distributed partitioned views?

0 Answers  


How do I create a stored procedure in sql server?

0 Answers  


What is serializable?

0 Answers  


What are the different types of subquery?

0 Answers  


What is the maximum size of sql server database?

0 Answers  


Categories