title: delete from table where rownum() = 3
body: <p>How to delete third row from any table using "rownum" (i'm using hsqldb)
  i try many query and the result return always = 0 
  for example this one -> </p>
  
  <pre><code>SELECT ROW_NUMBER FROM
  
  (SELECT ROWNUM() AS ROW_NUMBER, abs.* FROM absence abs)
  
  WHERE ROW_NUMBER = 3;
  </code></pre>