Prev Next

NULL Keyword

The NULL keyword represents a missing or undefined value in a database. It is not the same as zero or an empty string.

Example: Checking for NULL Values

SELECT Name
FROM FreedomFighters
WHERE Contribution IS NULL;

Output:

Returns the names of freedom fighters whose contributions are not specified.

Notes

  • Use IS NULL or IS NOT NULL to check for NULL values.
  • Remember that NULL represents the absence of a value, not an empty or zero value.
Prev Next