rand()

Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Returns a random number.

rand()
rand(1000)

Syntax

• rand() - returns a value of type real with a uniform distribution in the range [0.0, 1.0).
• rand( N ) - returns a value of type real chosen with a uniform distribution from the set {0.0, 1.0, ..., N - 1}.

Learn more about syntax conventions.