NULL

From SQLZOO
Revision as of 13:38, 27 February 2015 by Andr3w (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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