Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rewrite subqueries into simple select statements or
with joins? Example?
- 2 Answers
- 9136 Views
- ASD Lab, I also Faced
- E-Mail Answers
Answer Posted / divya kalra
Subqueries can often be re-written to use a standard outer
join, resulting in faster performance. As we may know, an
outer join uses the plus sign (+) operator to tell the
database to return all non-matching rows with NULL values.
Hence we combine the outer join with a NULL test in the
WHERE clause to reproduce the result set without using a
sub-query.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is the Disadvantage of indexed sequential file.
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is the difference between char and varchar2 datatype in sql?
what's new in sql server 2016?
What is the purpose of indexing?
What happens if the update subquery returns multiple rows in ms sql server?
What are the different types of sql server replication? : sql server replication
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to get @@error and @@rowcount at the same time?
What are drilldown reports?
Explain transaction server auto commit?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is sql language?
What happens if null values are involved in boolean operations?
