Exam4Training

What should you do?

You have two tables in an ANSI-SQL compliant database with identical columns that you need to quickly combine into a single table, removing duplicate rows from the result set.

What should you do?
A . Use the JOIN operator in SQL to combine the tables.
B . Use nested WITH statements to combine the tables.
C . Use the UNION operator in SQL to combine the tables.
D . Use the UNION ALL operator in SQL to combine the tables.

Answer: C

Explanation:

Reference: https://www.techonthenet.com/sql/union_all.php

Exit mobile version