UNION versus UNION ALL

QuizEasyAsked in: Accenture, TCS

How do UNION and UNION ALL differ?

Choose one answer.

UNION removes duplicate rows from the combined result; UNION ALL keeps every row
UNION keeps duplicates; UNION ALL removes them
UNION ALL puts the columns side by side
There is no difference

to answer and keep your progress. Reading is free for everyone.