title: Create multiple pages in an HTML file with navigation links
body: <p>I have a table in a SQL server database, that holds about 20 000 records. I want to display all the records in an HTML or ASP page. But it must be displayed in such a way that the user can only see the first 100 records and with a navigation link or button he can go to another page where, he can see the next 100 records.</p>
  
  <p>For instance the user should have the following options available for navigation:
  <code>First page</code>, <code>Previous page</code>, <code>Next page</code>, <code>Last page</code></p>
  
  <p>With the <code>First page</code> - the user can navigate and view the first 100 records.</p>
  
  <p><code>Previous page</code> - view the previous 100 records</p>
  
  <p><code>Next page</code>  - view next 100 records</p>
  
  <p><code>Last page</code>  - view last 100 records</p>
  
  <p>I am not a 100% sure how to go about this. I thought of embedding other HTML pages within another that hold each set of 100 records, but sounds oddly wrong. I also thought about a sql query that for the first page it chooses the top 100 records and when a user press <code>Next page</code>, the query adjust and checks the current records/position and choose the next 100 records, which sounds like a viable option. But can someone give a few tips or examples, just so i can get some kind of reference that can help me on where to start. </p>