Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 13777 Views
- CarrizalSoft Technologies, CTS, I also Faced
- E-Mail Answers
Answer Posted / amit dixit
Just Above is OK except UNION ALL result modified..
Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth
Result Set:
UNION: First,Second,Third,Fourth,Fifth,Sixth (This will
remove duplicate values)
UNION ALL:
First,First,Second,Second,Third,Fourth,Fifth,Fifth,Sixth
(This will repeat values)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain what is the function of sql server agent windows service?
what is raid? : Sql server database administration
When you should use a low fill factor?
What is dbcc?
What is the New in SQL server 2008?
What is snapshot parameter in ssrs?
State the difference between local and global temporary tables?
What are the differences between lost updates and uncommitted dependencies?
What is the use of builtinadministrators group in sql server? : sql server security
What is dbcc? Give few examples.
Give the query of getting last two records from the table in SQL SERVER?
Do you know how to implement service broker?
Can you tell me about the concept of ER diagrams?
what are constraints? : Sql server database administration
How can we solve concurrency problems?
