Standard Feature-IDs
T611, “Elementary OLAP operations”: nulls last
, nulls first
The implementation defined item ID133, “The implicit null ordering when null ordering is not specified“ is defined in ISO/IEC 9075-2:2023. The standard edition of 1989 did explicitly defined the null ordering as “implementator defined“ but also required null
values to be treated either greater or smaller than non-null values. This remained standard until 2003, when nulls first | last
was introduced. Since then, the <null ordering>
is implementation defined and may depend on the presence of asc
and desc
but must not depend on context outside the order by
clause.
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 »