db-derby-user mailing list archives

unludo wrote:
> OK thanks a lot for your answers.
> 
> Regarding the 'ORDER BY RANDOM()', you also plan to have something similar?


ORDER BY RANDOM() already works for me. Example:

ij> select i from t where i < 5;
I
-----------
1
2
3
4

4 rows selected
ij> select i from t where i < 5 order by random();
I
-----------
1
2
4
3

4 rows selected
ij>


-- 
Øystein