The UNION keyword in SQL is used to combine the results of two or more SELECT queries into a single result set while 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 in some database systems for data merging).

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

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