Set Operators (Entity SQL)

Entity SQL provides various powerful set operations. This includes SQL-like set operators such as UNION, INTERSECT, EXCEPT, and EXISTS. Entity SQL also supports operators for duplicate elimination (SET), membership testing (IN), and joins (JOIN). The following topics describe the Entity SQL set operators:

• ANYELEMENT (Entity SQL)

• EXCEPT (Entity SQL)

• FLATTEN (Entity SQL)

• INTERSECT (Entity SQL)

• [NOT] EXISTS (Entity SQL)

• [NOT] IN (Entity SQL)

• OVERLAPS (Entity SQL)

• SET (Entity SQL)

• UNION (Entity SQL)

See Also

Concepts

Entity SQL Reference