title: Can a pagination do with only one sql query?
body: <p>As I know a pagination structure requires minimum two sql query. </p>
  
  <ul>
  <li><p>First, find total row </p></li>
  <li><p>Second, limit your query.</p></li>
  </ul>
  
  <p>Is there a way to decrease query to one. Can we use first sql query to manupulate the pagination? On first query we already fetch all necessary data. Is first query's array can handle this issue?</p>