title: List Last record of each item in mysql
body: <p>Each item(item is produced by Serial) in my table has many record and I need to get last record of each item so I run below code:</p>
  
  <pre><code>SELECT ID,Calendar,Serial,MAX(ID) 
  FROM store 
  GROUP BY Serial DESC
  </code></pre>
  
  <p>it means it must show a record for each item which in that record all data of columns be for last record related to each item but the result is like this:</p>
  
  <pre><code>-------------------------------------------------------------+
    ID    |            Calendar        |  Serial |    MAX(ID)  |
  -------------------------------------------------------------|
  7031053 |   2016-05-14 14:05:14 79.5 |  N10088 |    7031056  |
  7053346 |   2016-05-14 15:17:28 79.8 |  N10078 |    7053346  |
  7051349 |   2016-05-14 15:21:29 86.1 |  J20368 |    7051349  |
  7059144 |   2016-05-14 15:50:27 89.6 |  J20367 |    7059144  |
  7045551 |   2016-05-14 15:15:15 89.2 |  J20366 |    7045551  |
  7056243 |   2016-05-14 15:25:34 85.2 |  J20358 |    7056245  |
  7042652 |   2016-05-14 15:18:33 83.9 |  J20160 |    7042652  |
  7039753 |   2016-05-14 11:48:16 87   |  J20158 |    7039753  |
  7036854 |   2016-05-14 15:18:35 87.5 |  J20128 |    7036854  |
  7033955 |   2016-05-14 15:20:45 83.4 |  9662   |    7033955  |
  -------------------------------------------------------------+
  </code></pre>
  
  <p>the problem is why for example in record related to Serial N10088 the ID is "7031053", but MAX(ID) is "7031056"? or also for J20358?</p>
  
  <p>each row must show last record of each item but in my output it is not true!</p>