T152, “DISTINCT predicate with negation”

1. Not for row-values
2. Supports the non-standard spaceship operator instead: <=>

Related

• T151, “DISTINCT predicate”

• Tutorials:

  • NULL-Aware Comparison: is [not] distinct from

  • NULL: Indicating the Absence of Data

  • The Three-Valued Logic of SQL

Normative References

The optional feature T152, “DISTINCT predicate with negation” is defined in ISO/IEC 9075-2:2023. It first appeared in the release of 2003.