What keyword is missing from the following query in order to ensure that all results, including duplicates, are returned?

What keyword is missing from the following query in order to ensure that all results, including
duplicates, are returned?
SELECT time, action, user FROM log20040101
UNION
SELECT time, action, user FROM log20040102

What keyword is missing from the following query in order to ensure that all results, including
duplicates, are returned?
SELECT time, action, user FROM log20040101
UNION
SELECT time, action, user FROM log20040102

A.
NONDISTINCT

B.
DUPLICATE

C.
ALL

D.
RELAXED



Leave a Reply 0

Your email address will not be published. Required fields are marked *