SQL nullif returns the value of the first argument unless it equals the second argument—then it returns the null value.
SELECT NULLIF(int_expression, 0)
FROM …
The example returns the value of int_expression unless it contains the the value zero (0)—then it returns the SQL null value. This particular example is useful to prevent division by zero errors.
You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Bluesky or RSS to gradually catch up and to keep modern-sql.com on your radar.
About the Author
Markus Winand provides insights into SQL and shows how different systems support it at modern-sql.com. Previously he made use-the-index-luke.com, which is still actively maintained. Markus can be hired as trainer, speaker and consultant via winand.at.
