How to implement such a SQL statement with hql

zelonxdi

select * from (select my_table. *, rownum as my_rownum from (selete * from ZsysDept) my_table where rownum <16) where my_rownum> = 1

hyysios

The standard paging program in Hibernate.

hollylight

If you want to paginate Oracle, hibernate has encapsulated the function

zelonxdi

If multi-table join paging, can standard paging in hibernate be implemented? , The standard paging in hibernate seems to have a problem, and the content of the first page and the second page is somewhat duplicated