title: MySQL statement to get min value with max ID
body: <p>I want to select the minimum value with the largest id.  For example, I want to select Playstation because it has a larger id than Silly Puddy.</p>
  
  <p>This is my sql statement:</p>
  
  <pre><code>SELECT *, max(id), min(price)
  FROM table
  group by type
  ORDER BY id DESC 
  
  
  id      name                    type        price
  123451  Park's Great Hits       Music       19.99
  123452  Silly Puddy             Toy         3.99
  123453  Playstation             Toy         3.99
  </code></pre>
  
  <p>I keep getting Silly Puddy returned for Toy.  Any suggestions on what to do differently?
  Thanks in advance!</p>