Which keyword can be used to combine two results into one table?

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.