title: Skip rows in an unsorted list
body: <p>I have an Angular app which displays a list and a Scala API which provides data. I encountered a problem (and the languages don't matter, is just about logic).</p>
  <p>The problem is that the table from which I get data doesn't have a primary key. Because I need to display the data plain in a widget (of type table) without sorts, just like in the database, I just do &quot;<code>SELECT * FROM table LIMIT 30</code>&quot;.</p>
  <p>The problem is when I want to change the page, my query became <code>SELECT * FROM table OFFSET 30 LIMIT 30</code></p>
  <blockquote>
  <p>ERROR: OFFSET can not be used without an ORDER BY option.</p>
  </blockquote>
  <p>How can be solved this problem?</p>