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
Select the correct answer from above options
Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience