title: BigQuery Standard SQL: Delete Duplicates from Table
body: <p>I am using below query to delete duplicates records from bigquery using standard sql. but it is throwing error</p>
  
  <pre><code>with cte as (
  select * ,row_number()over (partition by CallRailCallId order by CallRailCallId) as rn
  from `encoremarketingtest.EncoreMarketingTest.CallRailCall2` )
  
  delete
   from cte
  where rn&gt;1
  </code></pre>
  
  <blockquote>
  <pre><code>Query Failed
  Error: Syntax error: Expected "(" or keyword SELECT but got keyword DELETE at [5:5]
  </code></pre>
  </blockquote>
  
  <p>Could anyone help me on the correct approach in BigQuery?</p>