Compound
Represents a compound SELECT statement in SQL, allowing the combination of results from multiple SELECT statements using operators like UNION, UNION ALL, EXCEPT, and INTERSECT.
This interface provides a fluent API to build complex queries by chaining these compound operators. Each method takes a lambda that returns a SelectStatement to be combined with the preceding one.
Inheritors
Functions
Appends an EXCEPT operator to the current query, returning rows from the first SELECT statement that are not present in the result set of the second SELECT statement.
Appends an INTERSECT operator to the current query, returning only the rows that are present in the result sets of both SELECT statements.
Appends a UNION operator to the current query, combining its result set with another SELECT statement.
Appends a UNION ALL operator to the current query, combining its result set with another SELECT statement.