persistence@glassfish.java.net

EJBQL: something equivalent to ORDER BY RANDOM() LIMIT 10;

From: unludo <unludo_at_gmail.com>
Date: Tue, 8 Apr 2008 20:25:14 -0700 (PDT)

i,

Here is an SQL query I use with PostgreSQL:

SELECT * FROM WORDS ORDER BY RANDOM() LIMIT 10;

I don't find an equivalent to RANDOM() and LIMIT in Java Persistence Query
Language.

If someone knows about that, I'd be glad to hear.

Thanks
Ludovic
-- 
View this message in context: http://www.nabble.com/EJBQL%3A-something-equivalent-to-ORDER-BY-RANDOM%28%29-LIMIT-10--tp16578589p16578589.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.