distinct
explicitlydistinct
not supportedE071, “Basic query expressions”
F301, “CORRESPONDING in query expressions”
F302, “INTERSECT table operator”
T551, “Optional key words for default syntax”
F303, “INTERSECT DISTINCT table operator”, is an optional feature of ISO/IEC 9075-2:2023. As F302-01 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.
You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Bluesky or RSS to gradually catch up and to keep modern-sql.com on your radar.
The essence of SQL tuning in 200 pages
Buy now!
(paperback and/or PDF)
Paperback also available at Amazon.com.
Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »