WGU Courses and Certificates Data-Management-Foundations Question # 17 Topic 2 Discussion

TheUNIONkeyword in SQL is used tocombine the resultsof two or more SELECT queries into asingle result setwhile removing duplicate rows.

Example:

sql

SELECT Name FROM Employees

UNION

SELECT Name FROM Managers;

Option A (Correct):UNION combines results from multiple queries into one set,removing duplicates.

Option B (Incorrect):MERGE is not a valid SQL keyword for combining result sets (it is used insome database systems for data merging).

Option C (Incorrect):INTEGRATE is not a SQL keyword.

Option D (Incorrect):CONSOLIDATE is not an SQL keyword.