What is the difference between UNION and UNIONALL?
- 5 Answers
- 12116 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
What does it mean to manipulate data?
How to write a query with an inner join in ms sql server?
Please explain what is “asynchronous” communication in sql server service broker?
Define constraints and give an example of their use?
List out the differences between global and local temp tables in sql server?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Suggest a method of joining two tables.
What is indexed view?
Explain about extended stored procedure?
What is coalesce in sql server?
Difference between Logical Page and Physical Page in SSRS.
What is reference section?
Write a program to fetch first 10 records from a file?
What is the default Port No on which SQL Server listens?
Explain the rules for designing files and file groups in sql server?
