Question Details

Detailed explanation and options for the selected question.

What does the UNION operation in SQL do?

A. Combines results of two queries without duplicates
B. Joins two tables
C. Filters rows based on conditions
D. Sorts rows in ascending order

Explanation:

UNION combines results of two queries and removes duplicates by default. JOIN links tables, WHERE filters rows, and ORDER BY sorts rows.