I just checked the javadoc of javax.persitence.Query, method setFirstResult and it says: anonymous wrote : Query setFirstResult(int startPosition) | | Set the position of the first result to retrieve. | | Parameters: | startPosition - the start position of the first result, numbered from 0 | Returns: | the same query instance | Throws: | IllegalArgumentException - if argument is negative | | So the index must be starting from 0. Even in my query the first result i get when i setFirstResult to 0 is the user id in first row in the table and get the second id when the setFirstResult is set to 1. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4159288#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...