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

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  


how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  


Is the order of columns in the set clause important in ms sql server?

0 Answers  


CREATE a table from another table

2 Answers  


What is the use of MOVE keyword in restore command

3 Answers   IBM,






To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  


Explain how many normalization forms?

0 Answers  


What are the extra roles available in msdb? : sql server security

0 Answers  


What is the default Port No on which SQL Server listens?

0 Answers  


SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  


What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  


What is a Join in SQL Server?

3 Answers  


Categories