What is the difference between UNION and UNIONALL?
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 how to send email from sql database?
How to convert numeric expression data types by assignment operations?
What are the types of joins in sql?
What is the current pricing model of SQL Azure?
What are “lock” hints?
where can you add custom error messages to sql server? : Sql server administration
What is transaction server explicit transaction?
Can we take the full database backup in log shipping?
write an SQL query to list the employees who joined in the month of January?
What are dml triggers and types of dml triggers?
Which are new data types introduced in sql server 2008?
What is catalog views?
Explain error and transaction handling in sql server?
Define synonym?
What are the types of dml?