The UNION ALL operator does not eliminate duplicate selected rows from the result set.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- UNION query returns only distinct rows and UNION ALL may return duplicates.
- The result of a SELECT statement can contain duplicate rows.
- The Union transformation does not remove duplicate rows and is similar to ________SQL statement
- UNION selects only distinct value by default.
- Fill Up: The UNION operator selects only distinct values by default. To allow duplicate values, use __________
- Consider the query: (select customer-name from depositor) union (select customer-name from borrower) The ou...
- What command eliminates the duplicates.
- deference between union and union all