Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNION and UNIONALL?
- 5 Answers
- 14157 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
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is left outer join in sql server joins?
How does index makes search faster?
What is a cube? : sql server analysis services, ssas
Write a code to select distinct records without using the DISTINCT keyword.
Ways to improve the performance of a SQL Azure Database?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
Explain the properties of a relational table?
explain different types of constraints? : Sql server database administration
what are user defined datatypes and when you should go for them? : Sql server database administration
what is a sub-report?
Where can you add custom error messages to sql server?
Explain “@@rowcount” and “@@error” in sql server?
What is the default value of an integer data type in sql server 2005?
What is the difference between web edition and business edition?
