JPA sub query examples for use in components.xml

[paulmkeogh]

Hi,

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 ?

Thanks,

[lvdberg]

Hi,

you must get the total number of the (ordered!) rows first and set the pointer to the last position-5.

Leo

P.S: This is basic Hibernate stuff and not really a question for this forum.