title: how to fetch only 80 rows from mysql database using Spring Data @query annotation?
body: <p>My query like this</p>
  
  <pre><code>@Query("select cnt from Content cnt  order by 
  CASE WHEN cnt.status = 'rejected' THEN '1' 
  WHEN cnt.status = 'modified'  ELSE cnt.status END ASC")
  </code></pre>
  
  <p>how to add limit <strong>0,100</strong> rows to add my <code>query</code>?</p>
  
  <p>I wrote below format ,but all rows fetched from <code>database</code></p>
  
  <pre><code>@Query("select cnt from Content cnt  
    order by CASE WHEN cnt.status = 'rejected' THEN '1' 
    WHEN cnt.status = 'modified'  ELSE cnt.status END ASC limit 0,100")
  </code></pre>