Set operations (SQL)

This article includes a list of general references, but it lacks sufficient corresponding inline citations. Please help to improve this article by introducing more precise citations. (July 2022) (Learn how and when to remove this message)

Set operations in SQL is a type of operations which allow the results of multiple queries to be combined into a single result set.^[1]

Set operators in SQL include UNION, INTERSECT, and EXCEPT, which mathematically correspond to the concepts of union, intersection and set difference.