title: How to add limit to Hibernate query annotation?
body: <p>I have this in Java Hibernate</p>
  
  <pre><code>@Query("SELECT dirPar FROM DirectiveParagraph dirPar, Directive dir  "
          + "WHERE dirPar.directive = dir "
          + "AND dir.txtDirCode = :txtDirCode ");
  
  List&lt;DirectiveParagraph&gt; getByName(@Param("txtDirCode") String name, @Param("page") int page ,@Param("size") int size);
  </code></pre>
  
  <p>I want to retrieve with limit and size, same way like this </p>
  
  <pre><code>SELECT * FROM tblDirectiveParagraph where intDirectiveID = 1 limit 10,10;
  </code></pre>
  
  <p>How do I add limit to above @Query annotation </p>