Can I use… F302-01, “INTERSECT DISTINCT table operator”

1. Requires the keyword distinct explicitly
2. Explicit keyword distinct not supported

Related

• E071, “Basic query expressions”

  • E071-03, “EXCEPT DISTINCT table operator”

• F301, “CORRESPONDING in query expressions”

• F302, “INTERSECT table operator”

  • F302-02, “INTERSECT ALL table operator”

• F304, “EXCEPT ALL table operator”

• T551, “Optional key words for default syntax”

Normative References

F302-01, “INTERSECT DISTINCT table operator”, is an optional feature of ISO/IEC 9075-2. It was present in SQL:1999, which was the first revision of the SQL standard that enumerated the individual features. In SQL-92 intersect—without the optional keyword distinct—was part of the intermediate level.