RAND Generates a random number between 0 and 1, which is returned as a float. : RAND « Math Functions « SQL Server / T-SQL Tutorial






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

------------------------
     0.16134333864034361

(1 rows affected)








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