Re: Proposed RAND() defn

> Maybe I don't understand RAND for SQL well enough but I thought that
> RAND() returns different numbers in
>
> FILTER(RAND()> 0.5&& RAND()< 0.6)
>
> (if you want the same number assign it in some way)
>
> As RAND() returns different numbers, so

MySQL:

select rand() as A , rand() as B from T ;

+-------------------+-------------------+
| A                 | B                 |
+-------------------+-------------------+
| 0.231994651474054 | 0.353741641485823 |
+-------------------+-------------------+
1 row in set (0.00 sec)

 Andy

Received on Thursday, 2 December 2010 12:13:09 UTC