What is the difference between UNION and UNIONALL?
- 5 Answers
- 12635 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 the first normal form(1nf)?
Why is normalisation important?
What are the 7 disadvantages to a manual system?
What is a hint?
Write a sql query to get zero records from a table having n number of records?
Do you know sql server 2008 backup compression?
What is outer join in sql server joins?
What are different types of views?
How to create percentile function?
What are the different authentication modes in sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Do you know clustered and non-clustered index?
Explain what are partitioned views and distributed partitioned views?
query processing
