Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8941 Views
- Saman Bank, Sonata, I also Faced
- E-Mail Answers
Answer Posted / anil_abbireddy
1. A UNION statement eliminates duplicate rows; a UNION ALL
statement includes duplicate rows.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Which is faster union or join?
State few characteristics of pl/sql?
What are stored procedures in mysql?
How do I create a sql script?
How many sql commands are there?
Is sql the best database?
How to connect a sql*plus session to an oracle server?
What is a behavioral trigger?
What do you know by pl/sql cursors?
How many joins can you have in sql?
How do you remove duplicates without using distinct in sql?
Which constraints we can use while creating database in sql?
How to pronounce postgresql?
Why is sql important?
Which are the different types of indexes in sql?
