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
- 8778 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
What makes a good primary key?
What is the difference between a query and a report?
What is the difference between drop and truncate commands?
What are pl/sql packages?
how can you see all indexes defined for a table? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is trigger price?
Which function is used to return remainder in a division operator in sql?
How do you update f as m and m as f from the below table testtable?
How do you select unique values in sql?
Can we join tables without foreign key?
Can you skip header records while loading? : aql loader
In what condition is it good to disable a trigger?
What is trigger with example?
What is difference between sql and excel?
