From: Mitesh Meswani <Mitesh.Meswani_at_Sun.COM>
Date: Tue, 08 Apr 2008 21:52:37 -0700

There is no equivalent of RANDOM() in JPQL. But, you can use
javax.persistence.Query.setMaxResult() to limit results to 10

unludo wrote:
> 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
>