hibernate - limit and offset in select query
843859Aug 4 2005 — edited Aug 31 2005
Hi All
is there any way to use limit and offset features of mysql in hibernate queries?
For exmple I have 100 rows in my results. I want to display the results page by page. How can I select rows starting from a particular index (for example from 10 to 20 instead of starting at the first record). The 'setMaxRows()' function can limit the number of results, but how can I specify the offset ? Thanks in advance.
regards
boolee