Subject

ZIP

Search

Sql

Asked • 04/11/19

What is the difference between UNION and UNION ALL?

What is the difference between `UNION` and `UNION ALL`?

More

1 Expert Answer

By:

Louis I. answered • 04/18/19

Tutor

4.9 (247)

Computer Science Instructor/Tutor: Real World and Academia Experienced

About this tutor ›

Hi! By default, a UNION applies a DISTINCT to a query's result set ... a "UNION ALL" instructs the SQL engine to NOT do that - no DISTINCT applied.

Upvote 0 Downvote

More

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.