UNION selects only distinct value by default.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- UNION query returns only distinct rows and UNION ALL may return duplicates.
- Fill Up: The UNION operator selects only distinct values by default. To allow duplicate values, use __________
- The UNION ALL operator does not eliminate duplicate selected rows from the result set
- The UNION ALL operator does not eliminate duplicate selected rows from the result set.
- UNION vs. UNION ALL
- Will union transformation allow duplicates?
- Can UNION be used along with outer join.
- subqueries cannot have union