title: SQL max product price
body: <p>I have a table of products and each record has the price it was sold at, which can vary</p>
  
  <pre><code>Product          Price
  a                2
  a                3
  a                4
  a                1
  b                10
  b                15
  b                20
  </code></pre>
  
  <p>I want a query which will give be the max price at which product a was sold and max price at which product b was sold and nothing more</p>
  
  <p>I have thousands of products so case will not help</p>