Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 14143 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / suresh
UNION statement effectively does a SELECT DISTINCT on the
results set. If you know that all the records returned are
unique from your union, use UNION ALL instead, it gives
faster results.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is etl - extraction, transformation, and loading?
What is the use of sql profiler in sql server 2012?
Explain an automatic checkpoint
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
what is a schema in sql server 2005? : Sql server database administration
What is nolock hint in sql server 2008
What is transactional replication?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How to receive returning result from a query?
What is @@rowcount in sql?
What are different types of table joins?
between cast and convert which function would you prefer and why?
What is the difference between functions and scalar functions?
How do you debug a procedure in sql server?
How to handle error or exception in sql?
