Which of the following is true about UNION, UNION ALL?

Options
- UNION eliminates duplicates, UNION ALL retains duplicates
- UNION retains duplicates, UNION ALL eliminates duplicates
- UNION and UNION ALL both eliminate duplicates
- UNION and UNION ALL both retain duplicated

CORRECT ANSWER : UNION eliminates duplicates, UNION ALL retains duplicates

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲