BigQuery SQL - COALESCE and IFNULL Functions
insights Stats
warning Please login first to view stats information.
articleArticles 578
imageDiagrams 58
commentComments 303
loyaltyKontext Points 6373
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.