select RAND() : RAND « Math Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Math Functions
  3. RAND
3> select RAND()
4> GO

------------------------
     0.28235054506303059

(1 rows affected)
1>








11.17.RAND
11.17.1.RAND Generates a random number between 0 and 1, which is returned as a float.
11.17.2.RAND Returns random number from 0 to 1.
11.17.3.select RAND()
11.17.4.SELECT RAND(22) Result