db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From unludo <unl...@gmail.com>
Subject limit, offset and random
Date Tue, 08 Apr 2008 05:26:15 GMT

Hello,

I would like to use the following constraints at the end of some queries:

SELECT a FROM B WHERE c = 'toto' ORDER BY RANDOM() LIMIT 10;

It is supposed to return 10 values randomly from the B table.

In fact I use that with postgresql.

Also if someone knows if ejbql supports a random() like operator in the
order by (I could not find it anywhere).

Thanks in advance, any help much appreciated.
Ludovic


-- 
View this message in context: http://www.nabble.com/limit%2C-offset-and-random-tp16547686p16547686.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message