title: DB query for deleting first 100 rows of a table in IBM Informix
body: <p>I tried with the following query but it didn't work.</p>
  
  <pre><code>delete from tableName where id IN (select FIRST 100 id from tableName)
  </code></pre>
  
  <p>Thanks in advance.</p>