title: MySQL - using GROUP BY and DESC
body: <p>In my SQL query I am selecting data with <strong>GROUP BY</strong> and <strong>ORDER BY</strong> clauses. The table has the same <code>numbers</code> across multiple rows with different times in each row. So I think I want to apply a <strong>GROUP BY</strong> clause.</p>
  
  <p>However in the results return the oldest time with the number, but I need the most recent time.</p>
  
  <pre><code>SELECT * FROM TABLE GROUP BY (numbers) ORDER BY time DESC
  </code></pre>
  
  <p>The query appears as if it should first apply <strong>GROUP BY</strong> and then <strong>ORDER BY</strong>... but the results do not appear to work this way. </p>
  
  <p>Is there any way to fix this?</p>