why is null not equal to null false

by

Because that behavior follows established ternary logic where NULL is considered an unknown value.

If you think of NULL as unknown, it becomes much more intuitive:

Is unknown a equal to unknown b? There’s no way to know, so: unknown.

More Related Contents:

  1. Best way to check for “empty or null value”
  2. Determine Oracle null == null
  3. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  4. Space used by nulls in database
  5. Sort by column ASC, but NULL values first?
  6. Not equal != operator on NULL
  7. Why does NULL = NULL evaluate to false in SQL server
  8. How to randomly select rows in SQL?
  9. What’s the difference between TRUNCATE and DELETE in SQL
  10. SQL best practice to deal with default sort order
  11. How can I get column names from a table in Oracle?
  12. single fixed table with multiple columns vs flexible abstract tables
  13. Primary key or Unique index?
  14. How to get a list of column names on Sqlite3 database?
  15. How to run a stored procedure in sql server every hour?
  16. Composite Primary key vs additional “ID” column?
  17. Questions every good Database/SQL developer should be able to answer [closed]
  18. Why do you create a View in a database?
  19. Logging ALL Queries on a SQL Server 2008 Express Database?
  20. How much disk-space is needed to store a NULL value using postgresql DB?
  21. Best database field type for a URL
  22. MySQL – how to front pad zip code with “0”?
  23. How can I implement SQL INTERSECT and MINUS operations in MS Access
  24. Postgres Error: More than one row returned by a subquery used as an expression
  25. Does ‘Select’ always order by primary key?
  26. How do I create and query linked database servers in SQL Server?
  27. Check if NULL exists in Postgres array
  28. SQL Inner Join On Null Values
  29. Temporal database design, with a twist (live vs draft rows)
  30. Executing SQL query on multiple databases

Leave a Comment