RND returns a random number between 0 and 1.

SYNTAX:

RND

EXAMPLES:

Return a random number between 5 and 10 to 1 decimal.

ROUND((10 - 5) * RND + 5,1)