Random select rows via JPA

Posted by Ke on Stack Overflow See other posts from Stack Overflow or by Ke
Published on 2010-03-17T00:15:39Z Indexed on 2010/03/17 0:21 UTC
Read the original article Hit count: 741

Filed under:
|

In Mysql,

SELECT id FROM table ORDER BY RANDOM() LIMIT 5

this sql can select 5 random rows. How to do this via JPA Query (Hibernate as provider, Mysql database)?

Thanks.

© Stack Overflow or respective owner

Related posts about jpa

Related posts about mysql