distinct
explicitlydistinct
not supportedE071, “Basic query expressions”
F301, “CORRESPONDING in query expressions”
F302, “INTERSECT table operator”
T551, “Optional key words for default syntax”
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.
The essence of SQL tuning in 200 pages
Buy on Amazon
(paperback only)
Paperback and PDF also available at Markus’ store.
Markus offers SQL training and consulting for developers working at companies of any size.
Learn more »