Q. Which of the following returns all distinct rows selected by either query?
β
Correct Answer: (C)
UNION
Explanation: The union operator is used to combine result set of two or more select statements. It avoids duplication