Math

RAND

BigQuery

Menghasilkan angka random antara 0 (inclusive) dan 1 (exclusive).

Tipe hasil: FLOAT64Diperbarui: 7 Jan 2026

Syntax

SQL

RAND()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT
2   RAND() as random_float,
3   CAST(RAND() * 100 AS INT64) as random_0_to_99;

Menghasilkan angka random.

Hasil

random_float	random_0_to_99
0.7234...	72

SQL

1 SELECT *
2 FROM `project.dataset.users`
3 ORDER BY RAND()
4 LIMIT 100;

Mengambil 100 random users.