title: delete all except first 100 ones
body: <p>I want to delete all rows where <code>date</code> contains <code>2018</code> but keep the first 100 ones.</p>
  
  <pre><code>delete from archive where date like '2018%' offset 100;
  </code></pre>
  
  <p>Suntax error near <code>offset 100</code>.</p>