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:2023. 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, Twitter 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 »