If we want to retain all duplicates, we must write ________ in place of union.
(a) Union all
(b) Union some
(c) Intersect all
(d) Intersect some
The question was posed to me during an internship interview.
This interesting question is from Set Operations topic in portion SQL : Queries, Constraints and Triggers of Database Management