special marker and keyword in SQL indicating that something has no value
Null (SQL) - Wikipedia
In the SQL database query language, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the creator of the โ€ฆ Wikipedia
Factsheet
Null (SQL)
Notation ฯ‰
Factsheet
Null (SQL)
Notation ฯ‰
๐ŸŒ
Wikipedia
en.wikipedia.org โ€บ wiki โ€บ Null_(SQL)
Null (SQL) - Wikipedia
September 25, 2026 - Null has been the focus of controversy and a source of debate because of its associated three-valued logic (3VL), special requirements for its use in SQL joins, and the special handling required by aggregate functions and SQL grouping operators. Computer science professor Ron van der Meyden summarized the various issues as: "The inconsistencies in the SQL standard mean ...
๐ŸŒ
MDN Web Docs
developer.mozilla.org โ€บ en-US โ€บ docs โ€บ Glossary โ€บ Null
Null - Glossary - MDN Web Docs
In computer science, a null value represents a reference that points, generally intentionally, to a nonexistent or invalid object or address. The meaning of a null reference varies among language implementations.
๐ŸŒ
W3Schools
w3schools.com โ€บ sql โ€บ sql_null_values.asp
SQL NULL Values - IS NULL and IS NOT NULL
A NULL value represents an unknown, missing, or inapplicable data in a database field.
๐ŸŒ
TheFreeDictionary.com
thefreedictionary.com โ€บ Null+value
Null value - definition of Null value by The Free Dictionary
Null value synonyms, Null value pronunciation, Null value translation, English dictionary definition of Null value. adj. 1. Having no legal force; invalid: render a contract null and void. 2. Of no consequence, effect, or value; insignificant.
๐ŸŒ
Biztory
biztory.com โ€บ blog โ€บ 7-things-you-should-know-about-null-values
7 Things to know about NULL values - Biztory
October 25, 2025 - Unfortunately, it is very common ... NULL values and other special markers (e.g. NaN, NA, Inf) might be cast into strings and treated like any other text field. This is particularly problematic because certain commands like IS NULL or LEN(0) won't work anymore, meaning you should ...
๐ŸŒ
GeeksforGeeks
geeksforgeeks.org โ€บ sql โ€บ sql-null-values
NULL values in SQL - GeeksforGeeks
January 5, 2026 - Some records in an SQL table may not have values for every field, and such fields are termed NULL values. These occur when data is unavailable during entry or when an attribute does not apply to a specific record.
Find elsewhere
๐ŸŒ
Khoury College of Computer Sciences
khoury.northeastern.edu โ€บ home โ€บ kenb โ€บ MeaningOfNull.html
The Meaning of Null in Databases and Programming Languages
The meaning of null in relational databases is a major source of confusion not only among database users but also among database textbook writers. The main distinction between the relational null and the programming language null is the following: The relational null represents the absence of a value in a field of a record; whereas the programming language null represents one of the possible values of a variable.
๐ŸŒ
freeCodeCamp
freecodecamp.org โ€บ news โ€บ a-quick-and-thorough-guide-to-null-what-it-is-and-how-you-should-use-it-d170cea62840
A quick and thorough guide to โ€˜nullโ€™: what it is, and how you should use it
June 12, 2018 - The Java Virtual Machine specification does not mandate a concrete value encoding null. ... If a reference points to null, it simply means that there is no value associated with it.
๐ŸŒ
Esri Support
support.esri.com โ€บ en-us โ€บ gis-dictionary โ€บ null-value
Null Value Definition | GIS Dictionary
[statistics, mathematics] The absence of a recorded value for a field. A null value differs from a value of zero in that zero may represent the measure of an attribute, while a null value indicates that no measurement has been taken.
Top answer
1 of 5
3

In simple worlds you can say that Null is not a data value, but a marker for an unknown value.

So any mathematical operations performed on NULL will result in NULL. For example,

10 + NULL = NULL

Similarly if you do string concatenation with string you get:-

'String ' || NULL || 'Concatenation'   -- Result is NULL

So you can say that Null means either "not applicable" or "don't know": it is not the same as zero (0) or any other default value, but more importantly, null is treated quite differently from other values in SQL, because it literally has no value.

An example to explain what it means when we say that NULL means UNKNOWN VALUE:

StudentName TestResult
X             78
A             89
B             67
C             NULL

So you can see that the student C got NULL marks in the test. So what does that mean?

Now one can say that the student does not sit in the test or it may be that the student's data is not avaialable. But it definitely does not mean that the student got 0(as if you assign 0 to the student then it would mean that the student appeared in the test and got zero) marks in the test. All we can say that the data for the student is

UNKNOWN or NULL

2 of 5
2

A field with a NULL value is a field with no value. It is very important to understand that a NULL value is different than a zero value or a field that contains spaces.

If a column in a table is optional, we can insert a new record or update an existing record without adding a value to this column. This means that the field will be saved with a NULL value.

NULL values are treated differently from other values.

NULL is used as a placeholder for unknown or inapplicable values. Read more about this here.

๐ŸŒ
W3Schools
w3schools.com โ€บ mysql โ€บ mysql_null_values.asp
MySQL NULL Values - IS NULL and IS NOT NULL
A NULL value represents an unknown, missing, or inapplicable data in a database field.
๐ŸŒ
MSSQLTips
mssqltips.com โ€บ home โ€บ sql null meaning and how to handle null values
SQL NULL Meaning and How to Handle NULL Values
September 1, 2026 - This is because the middle string, @String2, remains a NULL value, meaning that any concatenation that includes @String2 will also be NULL.
๐ŸŒ
Ieee
technav.ieee.org โ€บ ieee technology navigator โ€บ topics โ€บ null value
Null value | IEEE Technology Navigator
A null value is a special marker used in computing and database systems to indicate that a data item has no assigned value, that the value is unknown, or that the concept of a value does not apply in a given context.
๐ŸŒ
LearnSQL.com
learnsql.com โ€บ blog โ€บ what-is-null-in-sql
What Is a NULL in SQL? | LearnSQL.com
Simply put, an SQL NULL means that we donโ€™t have a value for that particular field.
๐ŸŒ
Enki
enki.com โ€บ post โ€บ understanding-null-values-in-sql
Enki | Blog - Understanding NULL Values in SQL
This distinction is important for understanding the integrity and behavior of database queries. Unlike a zero value, which indicates a known absence, or an empty string, which represents a present but empty value, NULL signifies the absence of any data value.
๐ŸŒ
Modern SQL
modern-sql.com โ€บ concept โ€บ null
Modern SQL: NULL โ€” purpose, comparisons, NULL in expressions, mapping to/from NULL
SQLโ€™s NULL indicates absent data. NULL propagates through expressions and needs distinct comparison operators.