title: Deleting dup DB2 data from CTE
body: <p>I have the following DB2 code which lists some duplicate incorrect rows, that I need to delete.  Can anyone help turn this into a delete statement?</p>
  
  <pre><code>with AN as (select AN 
              from SCHEMA1.ACCR 
              where TIME = '2013-06-01')  
  select * 
  from AN a 
  inner join SCHEMA1.ACCR b 
          on a.AN = b.AN 
  where TIME = '2012-06-01'
  </code></pre>
  
  <p>Thanks!</p>