HOME/🔍 BigQuery/

COUNTIF関数

Article Outline

|| countif()

Excelや、Spreadsheetではお馴染み、countif()

BigQueryでも使えるよ。

select
    count(if({}, true, false)) as COUNT_HOGE
select 
    countif({}) as COUNT_HOGE

|| cf.

  • -
  • -
  • -