Archives of the TeradataForum

Message Posted: Fri, 04 Mar 2005 @ 10:53:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

RANDOM function cannot be used with column values.

RANDOM(Lower Limit,Upper Limit) generates a random integer number for each row of the result table.

     SELECT STORE_COUNT, RANDOM(1,5) FROM ...;

Thanks,

Vimala.

	<Prev	Next>		<<First	<Prev	Next>	Last>>