Re: [eclipselink-users] ORDER BY RANDOM() in JPA?

[cowwoc <cowwoc@xxxxxxxxxxxxxxxx>]

http://stackoverflow.com/questions/19412/how-to-request-a-random-row-in-sql
suggests a more efficient implementation but depends upon the existence of
RAND(). Does JPQL guarantee the existence of all SQL-92 or SQL-99 functions?
Can I assume that RAND() is defined?

Gili


cowwoc wrote:
> 
> Hi,
> 
> Is there a portable way to select N random rows using JPA?
> http://www.petefreitag.com/item/466.cfm lists different vendor-specific
> ways to do this but obviously I would prefer using a portable JPA query
> instead.
> 
> Thank you,
> Gili
> 

-- 
View this message in context: http://www.nabble.com/ORDER-BY-RANDOM%28%29-in-JPA--tp21197746p21197813.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.