Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 13973 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / subramanya gv
Union is used to combining the data with out duplication and
effectively it is faster.
Union all is used to combining the data with duplication so
comparatively it is slower.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
In case you have filters in your report, when filters will be applied in cached report instance?
What is acid properties?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is sparse columns of sql server 2008?
What is @@error in sql?
What is the use of “join” in sql server?
What is the difference between a clustered index and a non-clustered index?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How do you open a cluster administrator?
What is an sql server agent?
What is temporal table?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
How to download and install microsoft sql server management studio express?
Write an sql query for deleting duplicate rows?
How do I schedule a sql server profiler trace?
