title: Cannot recognize input near 'DELETE' 'FROM' 'CTE' in statement
body: <p>I want to drop duplicates in <code>mytable</code> if there are identical value in <code>col1</code>.</p>
  
  <pre><code>WITH CTE AS
  (
      SELECT 
          *, ROW_NUMBER() OVER (PARTITION BY col1 ORDER BY col1) AS RN
      FROM
          mytable
  )
  DELETE FROM CTE 
  WHERE RN &lt;&gt; 1
  </code></pre>
  
  <p>I got error: </p>
  
  <blockquote>
    <p>Cannot recognize input near 'DELETE' 'FROM' 'CTE' in statement</p>
  </blockquote>