Advertisements
Advertisements
Question
Which set operation should be used with the SELECT statements to eliminate duplicate rows?
Options
Union
Union all
Intersect
Minus
MCQ
Solution
Union
Explanation:
The duplicate rows are removed from the result set of the union operation.
shaalaa.com
Operations on Relations
Is there an error in this question or solution?