BigQuery SQL - COALESCE and IFNULL Functions
insights Stats
warning Please login first to view stats information.
Raymond
Code Snippets & Tips
Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.
Similar as other databases, BigQuery also supports a large number of SQL dialects. COALESCE and IFNULL functions are provided to deal with nullable values.
COALESCE
SELECT coalesce(NULL, 1, 2) as Col;
Output (in JSON format):
[ { "Col": "1" } ]
IFNULL
SELECT ifnull(NULL, 1) AS Col;
Output (in JSON format):
[ { "Col": "1" } ]
copyright
This page is subject to Site terms.
comment Comments
No comments yet.