title: SQl Delete top 100 from table
body: <p>I am trying to delete the all but the most recent 3,000 items in a table.  The table has 105,000 records.</p>
  
  <p>I am trying this, but an error is generated incorrect syntax.</p>
  
  <pre><code>delete tRealtyTrac where creation in( select top 103000 from tRealtyTrac order by creation)
  </code></pre>