title: Sqlite select max query and sorting
body: <p>I have the following fields on a SQLite table, </p>
  
  <pre><code>  ID - PRODUCT_NAME - PRODUCT_PRICE
    1    WCC9899        1023
    2    WCC9399        9999
    3    WCC93W9        344
    4    WCC9819        55
    5    WCC3333        1023
  </code></pre>
  
  <p>This query returns the <strong>first</strong> item with the highest price:</p>
  
  <pre><code> SELECT max(product_price) as price, product_name, id FROM table
  </code></pre>
  
  <p>But want to get the item with the <strong>highest</strong> price ordered by the <strong>last id</strong>, in this case the result should be:  </p>
  
  <pre><code> 5    WCC3333        1023
  </code></pre>
  
  <p>Instead i get:</p>
  
  <pre><code> 1    WCC9899        1023
  </code></pre>
  
  <p>Order by doesn't works, ty.</p>