title: Deleting top rows only. SQL Server
body: <p>How do I delete only the top row of a table in SQL Server?</p>
  
  <p>I did:</p>
  
  <pre><code>set rowcount 1;
  delete * from table;
  set rowcount 0;
  </code></pre>
  
  <p>But I am not sure if its a good way to do it.</p>
  
  <p>Is there any better way to accomplish that?</p>