Courses / SQL
22. UNION operator
An operator that combines the result sets of two or more SELECT statements.
1 min read Chapter 22 of 29
SQL
UNION operator
The UNION operator combines the results of two or more SELECT statements into a single result set.
"I want to gather data from different tables without writing separate queries for each."
The UNION operator allows you to merge the result sets of multiple SELECT queries, eliminating duplicate rows by default.
"I want to gather data from different tables without writing separate queries for each."
The UNION operator allows you to merge the result sets of multiple SELECT queries, eliminating duplicate rows by default.