title: How to delete the top 1000 rows from a table using Sql Server 2008?
body: <p>I have a table in SQL Server.  I would like to delete the top 1000 rows from it.  However, I tried this, but I instead of just deleting the top 1000 rows it deleted all the rows in the table.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>delete from [mytab] 
  select top 1000 
  a1,a2,a3
  from [mytab]
  </code></pre>