title: DELETE FROM (Select...) SAP HANA
body: <p>This may be specific to SAP HANA, but how come this does not work and is there a recommended workaround:</p>
  
  <pre><code>DELETE FROM
  (SELECT
   PKID
  , a
  , b)
  Where a &gt; 1 
  </code></pre>
  
  <p>There is a Syntax Error at "("</p>
  
  <p>In fact, <code>DELETE FROM (TABLE) where a &gt; 1</code> does not work either and gives the same syntax error.</p>
  
  <p>The problem is that I need to delete specific rows that are flagged used a Rank function in my select statement.</p>
  
  <p>Thanks (first post, been lurking and searching forever).</p>
  
  <p>-CW</p>