Informatics Practices
UNION returns unique rows.
SQL Joins & Grouping
1 Like
Answer
True
Reason — The UNION operator returns all unique rows from the SELECT queries.
Answered By
3 Likes
Related Questions
Outer join has all the rows from both the tables.
MINUS operator is also called EXCEPT operator.
UNION and UNION ALL produce similar results.
Assertion. Cartesian product and joins are related.
Reason. Cartesian product is a join without any condition.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.