title: Select the last two records in sql server when there is no identity column
body: <p>Data:</p>
  
  <pre><code>Name  Desc
  Daman XXXX
  Sam   XXXX
  Ram   XXXX
  Sun   XXXX
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>Name Desc
  Sun  XXXX
  Ram  XXXX
  </code></pre>
  
  <p>There is no identity column. So far I have tried the below but its not helpful</p>
  
  <pre><code>select *, Rank() over(order by Name ) as [Rank] from testdaman
  </code></pre>