title: Last id value in a table. SQL Server
body: <p>Is there a way to know the last <code>nth</code> id field of a table, without scanning it completely? (just go to the end of table and get id value)</p>
  
  <pre><code>table
  id   fieldvalue
  1    2323
  2    4645
  3    556
  ...  ...
  100000000  1232
  </code></pre>
  
  <p>So for example here <code>n = 100000000</code> 100 Million</p>
  
  <p><strong>--------------EDIT-----</strong>
  So which one of the queries proposed would be more efficient?</p>