db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen <Oystein.Grov...@Sun.COM>
Subject Re: limit, offset and random
Date Wed, 09 Apr 2008 06:45:31 GMT
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

Mime
View raw message