title: PostgreSQL - repeating rows from LIMIT OFFSET
body: <p>I noticed some repeating rows in a paginated recordset.</p>
  
  <p>When I run this query:</p>
  
  <pre><code>SELECT "students".* 
  FROM "students" 
  ORDER BY "students"."status" asc 
  LIMIT 3 OFFSET 0
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>    | id | name  | status |
      | 1  | foo   | active |
      | 12 | alice | active |
      | 4  | bob   | active |
  </code></pre>
  
  <p>Next query:</p>
  
  <pre><code>SELECT "students".* 
  FROM "students" 
  ORDER BY "students"."status" asc 
  LIMIT 3 OFFSET 3
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>    | id | name  | status |
      | 1  | foo   | active |
      | 6  | cindy | active |
      | 2  | dylan | active |
  </code></pre>
  
  <p>Why does "foo" appear in both queries?</p>