title: Select records by first row and page size
body: <p>I'm trying to implement lazy loading and pagination in my front end. I've been supplied the following two variables by the front end:</p>
  
  <ul>
  <li><code>firstRow</code> - the index of the first record to return in results of the select query.</li>
  <li><code>pageSize</code> - the total size of the records which the select query must return, starting at <code>firstRow</code>.</li>
  </ul>
  
  <p>How can I use them in a select query in MyBatis in order to return the desired subset of records?</p>