NULL

From SQLZOO
Jump to: navigation, search
schema:gisq

The NULL value may be used to indicate missing or unknown data. You can use the phrase IS NULL to select these values.

 
SELECT name,gdp
FROM world
WHERE gdp IS NULL