title: How to Select these record by MYSQL Statement?
body: <p>I have a Table: </p>
  
  <pre><code>tblUserLoginRecord  
  ID ||  User || LoginTime  
  1  ||  Peter|| 2017-07-03  
  2  ||  Susan|| 2017-07-04  
  3  ||  Sam  || 2017-07-05  
  4  ||  Sam  || 2017-07-07  
  5  ||  Sam  || 2017-07-08  
  6  ||  Susan|| 2017-07-09    
  </code></pre>
  
  <p>I want to have a result that show the last LoginTime Group By User(Using ID DESC will be fine too):</p>
  
  <pre><code>ID ||  User || LoginTime  
  1  ||  Peter|| 2017-07-03  
  5  ||  Sam  || 2017-07-08  
  6  ||  Susan|| 2017-07-09 
  </code></pre>
  
  <p>How I do it now is:  </p>
  
  <pre><code>SELECT * FROM (SELECT * FROM tblUserLoginRecord ORDER BY ID DESC) a GROUP BY User;  
  </code></pre>
  
  <p>But it will be much slower if the table growth bigger. How can I make it better?
  Thank you.</p>