title: How to get last inserted row from table?
body: <p>My table is like below:</p>
  
  <pre><code>Id  Data   Date 
  A   abc    2016-10-01 00:00:00
  A   def    2015-05-20 00:00:00
  B   xyz    2014-05-20 00:00:00
  B   uvw    2016-10-01 00:00:00
  B   rst    2015-10-01 00:00:00
  </code></pre>
  
  <p>I need to get the last inserted row by column Id. So expected output will be:</p>
  
  <pre><code>Id  Data   Date
  A   def    2015-05-20 00:00:00
  B   rst    2015-10-01 00:00:00
  </code></pre>
  
  <p>I can be able to get the last inserted row by Identity column or by inserted date column if I have. But how to get last inserted row without these columns?</p>