BigQuery SQL - COALESCE and IFNULL Functions

visibility 404 comment 0 access_time 9m languageEnglish

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.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Tags