[jboss-user] [EJB 3.0] - Re: random selection with ejbql

merabi do-not-reply at jboss.com
Mon Apr 9 09:42:55 EDT 2007

thanks for the reply, but I still need to know if EJBQL allows random selection from the record.

for example, MySQL allows query:

select * from Table1 order by rand() limit 5;

I've searched half a day if EJBQL can do sucha thing but found no info.

Is there anyway I can select random records using EJBQL?

(My boss doesn't wanna use createNativeQuery. That make it more though...)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4035707#4035707

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4035707

More information about the jboss-user mailing list