title: Delete first X lines of a database
body: <p>is there an SQL command to delete the first X lines of a database table?</p>
  
  <p>I have a database table containing some information but no id or auto-incrementing value and a program that processes the first X lines of this table.
  Afterwards these X lines need to be deleted. So the standard query is:</p>
  
  <pre><code>DELETE FROM table WHERE something = value;
  </code></pre>
  
  <p>So, is there a way to build a query like:</p>
  
  <pre><code>DELETE FROM table WHERE rownumber &lt;= X;
  </code></pre>
  
  <p>I have tried this command, but nothing happens to the database..
  Do you have any clue?</p>