The UNION operator combines the results of two or more SELECT queries into a single result set – as if it came from a single query. It merges the rows from different queries, removes duplicate rows, and presents a unified result.
