DA0-002: CompTIA Data+ V2

By CompTIA · Question Mode

QuestionQ8

Data analysis

A data analyst must combine results from two separate queries with similar data and an equal number of columns. The output must contain distinct rows. Which of the following should the data analyst use?

Explanation

The SQL UNION operation combines the results of independent queries with compatible columns and, by default, excludes duplicate rows. UNION ALL would retain duplicates.

Learn more

Community Discussion

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