That is only possible if you do a retrieve from database.

When doing a retrieve by association, it will always retrieve the complete list of associated objects. You can only filter afterwards. But some limit/offset filtering is not doable out of the box. You could do this in loops or you could create a java action that is doing this for your list.