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
- 8823 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
What is the non-clustered index in sql?
What is t sql in sql server?
What is assignment operator in pl sql?
What does an inner join do?
What are different functions in sql?
Mention what does plv msg allows you to do?
Is sql difficult?
write an sql query to find names of employee start with 'a'? : Sql dba
how can you create an empty table from an existing table? : Sql dba
What is faster join or subquery?
What does count (*) do in sql?
Mention what are the benefits of pl/sql packages?
How many types of normalization are there?
what is the different between now() and current_date()? : Sql dba
explain access control lists. : Sql dba
