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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...