Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 13975 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 do you understand by the analysis services in sql server?
How to loop through the result set with @@fetch_status?
How to create a ddl trigger using "create trigger" statements?
What are locks in sql?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
How to enter binary string literals in ms sql server?
What is a deadlock and what is a live lock?
What is an example of a primary key?
What is filestream?
What is a raid and what are different types of raid configurations?
What is Extended user-defined?
what does the automatic recovery do? : Sql server administration
Explain log shipping?
Explain the purpose of indexes?
Where is localdb stored?
