Math
Snowflake
RANDOM
SnowflakeMenghasilkan angka random integer 64-bit.
Tipe hasil:
INTEGERDiperbarui: 6 Jan 2026Syntax
SQL
RANDOM([seed])Parameter
seedINTEGERopsional
Seed untuk reproducible random (opsional)
Contoh Penggunaan
Random Number
SQL
1 SELECT RANDOM() as rand;
Generate random integer.
Random 0-1
SQL
1 SELECT UNIFORM(0::FLOAT, 1::FLOAT, RANDOM()) as rand_float;
Random float antara 0 dan 1.
Random Sample
SQL
1 SELECT * FROM users 2 ORDER BY RANDOM() 3 LIMIT 100;
Mengambil 100 random users.