I want to put all my queries into components.xml if possible.
I need a query that will return the last N rows of a sorted list - anything I've read suggests to use a sub-query but I cannot get it to work for me. I am using the Hibernate Console to test.
Anyone got any examples they want to share ?
you must get the total number of the (ordered!) rows first and set the
pointer to the last position-5.
P.S: This is basic Hibernate stuff and not really a question for this forum.