How do you do a limit query in HQL

Posted by stevedbrown on Stack Overflow See other posts from Stack Overflow or by stevedbrown
Published on 2009-08-06T15:33:22Z Indexed on 2010/03/11 21:19 UTC
Read the original article Hit count: 327

Filed under:
|
|

In Hibernate 3, is there a way to do the equivalent of the following MySql limit in HQL.

select * from a_table order by a_table_column desc limit 0, 20;

I don't want to use setMaxResults if possible. This definitely was possible in the older version of Hibernate/HQL, but seems to have disappeared.

© Stack Overflow or respective owner

Related posts about java

Related posts about hibernate