If we use where clause in the left outer join then how the
query would behave/act?
Answer Posted / prabir4prabir
It will act as a inner join.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are various limitations of the views?
What are the authentication modes in sql server? How can it be changed?
What is shrink log file?
How to use subqueries in the from clause in ms sql server?
What is an indexed view?
How to delete duplicate rows in sql server?
Why should one not prefix user stored procedures with ‘sp_’?
What is database isolation in sql server? : sql server database administration
How to enter comments in transact-sql statements?
How to replace the Query Result 'Null Value' with a text ?
Explain error and transaction handling in sql server?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What are xml indexes?
optimization techinques
How to count duplicated values in a column in ms sql server?