QuestionQ63

VerifiedBuilding and testing applications

You have two tables in an ANSI-SQL-compliant database with identical columns that need to be quickly combined into one table, with duplicate rows removed from the result set.

What should you do?

Explanation

The SQL UNION operator combines the results of compatible queries into one result set and excludes duplicate rows. UNION ALL instead retains duplicates.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!