In fact, it can't - different DBs use different SQL syntax. Therefore it's not at all unreasonable for a JPA implementation to add an "order by" if it's necessary to implement setFirstResult ...