What is the main difference between a UNION statement and a
UNION ALL statement?
1. A UNION statement eliminates duplicate rows; a UNION
ALL statement includes duplicate rows.
2. A UNION statement can be used to combine any number of
queries; a UNION ALL statement can be used to combine a
maximum of two queries.
3. A UNION statement can only combine queries that have
parallel fields in the SELECT list; a UNION ALL statement
can combine queries with differing SELECT list structures.
4. A UNION statement cannot be used with aggregate
functions; a UNION ALL statement can be used with aggregate
functions.
5. There is no difference between the two statements; they
are interchangeable.
- 2 Answers
- 7671 Views
- Saman Bank, Sonata, I also Faced
- E-Mail Answers
Answer Posted / menan
A UNION statement eliminates duplicate rows; a UNION
ALL statement includes duplicate rows.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why is a primary key important?
What is an implicit commit?
What is the importance of sqlcode and sqlerrm?
What is meant by truncate in sql?
What are different types of indexes?
Why do we use joins in sql?
What port does sql server use?
What is serial sql?
Will truncate release space?
What are different functions in sql?
what is unique key constraint? : Sql dba
What is a table partition?
what is the difference between truncate and drop statements? : Sql dba
What is a behavioral trigger?
How can I see all tables in sql?
