sql array 数组基本用法(一)

SELECT [1, 2, 3] as numbers;

SELECT ["apple", "pear", "orange"] as fruit;

SELECT [true, false, true] as booleans;

SELECT [a, b, c]
FROM
  (SELECT 5 AS a,
          37 AS b,
          406 AS c);

SELECT [a, b, c]
FROM
  (SELECT CAST(5 AS INT64) AS a,
          CAST(37 AS FLOAT64) AS b,
          406 AS c);

SELECT ARRAY<FLOAT64>[1, 2, 3] as floats;

SELECT GENERATE_ARRAY(11, 33, 2) AS odds;

odds

[11, 13, 15, 17, 19, 21, 23, 25, 27, 29, 31, 33]

SELECT GENERATE_ARRAY(21, 14, -1) AS countdown;

countdown

[21, 20, 19, 18, 17, 16, 15, 14]

SELECT
  GENERATE_DATE_ARRAY('2017-11-21', '2017-12-31', INTERVAL 1 WEEK)
    AS date_array;

date_array

[2017-11-21, 2017-11-28, 2017-12-05, 2017-12-12, 2017-12-19, 2017-12-26]