Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 13713 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
what are isolation levels? : Sql server database administration
How can we remove orphan records from a table?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
what stored procedure would you use to view lock information? : Sql server administration
What do you know about normalization and de- normalization?
What is database white box testing?
Can you insert NULL in unique column?
what data regions are and what are the different data regions?
Explain difference between cross join and full outer join?
What happens when unicode strings concatenate with non-unicode strings?
What are the different types of indexes?
How many databases Microsoft SQL server provides?
What is normalization and its types?
How many types of triggers are there?
Explain intellisense for query editing
