title: JPQL Query Annotation with Limit and Offset
body: <p>I have a repository interface with some abstract methods where I use the @Query annotation.
  Now I would like to add limit and offset support to this queries.</p>
  
  <p>example:</p>
  
  <pre><code>public interface ProductRepository
     extends CrudRepository&lt;Product, Long&gt; {
  
      @Query("from Product")
      List&lt;Product&gt; findAllProducts();
  }
  </code></pre>
  
  <p>something like this would be nice</p>
  
  <pre><code>public interface ProductRepository
     extends CrudRepository&lt;Product, Long&gt; {
  
      @Query("from Product limit :limit ")
      List&lt;Product&gt; findAllProducts(@Param("limit") Integer limit);
  }
  </code></pre>
  
  <p>But this doesn't work. There is a solution that I create an implementation of the interface (http://stackoverflow.com/questions/3479128/jpql-limit-number-of-results) 
  But I wonder if there is not a possibility of adding offset and limit to the query or if there is an annotation for this. </p>