0

More than 1 year has passed since last update.

BigQueryで最頻値を取得する

Posted at 2022-02-14

SELECT
  APPROX_TOP_COUNT(value,1)[OFFSET(0)].value AS mode
FROM
  dataset.table;

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0