title: SQL Server SELECT LAST N Rows
body: <p>This is a known question but the best solution I've found is something like:</p>
  
  <pre><code>SELECT TOP N *
  FROM MyTable
  ORDER BY Id DESC
  </code></pre>
  
  <p>I've a table with lots of rows. It is not a posibility to use that query because it takes lot of time. So how can I do to select last N rows without using ORDER BY?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Sorry duplicated question of <a href="https://stackoverflow.com/questions/311054/how-do-i-select-last-5-rows-in-a-table-without-sorting">this one</a></p>