title: Spring Data JPA apply sorting, pagination along with a where clause
body: <p>I am currently Using Spring JPA and utilizing the Sorting and Pagination as described here -</p>
  
  <p><a href="https://stackoverflow.com/questions/10527124/how-to-query-data-via-spring-data-jpa-by-sort-and-pageable-both-out-of-box">How to query data via Spring data JPA by sort and pageable both out of box？</a></p>
  
  <p>Now my question is how do I apply a 'where' clause to this?</p>
  
  <p>E.g. </p>
  
  <pre><code>where PRODUCT_NAME='abc';
  </code></pre>