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 is 2nf example?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Describe the left outer join & right outer join. : sql server database administration
Explain for xml explicit mode?
Do you know what are acid properties of transaction?
What is transactional replication?
What are the advantages of sql stored procedure?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is an active database?
If no size is defined while creating the database, what size will the database have?
What is difference between global temporary tables and local temporary tables?
What number sorts of privileges are accessible in sql?
What is table constraint?
How to concatenate two strings in SQL Server.
How will you monitor replication latency in transactional replication? : sql server replication