title: Selecting top item in set in SQL
body: <p>I have a single table that has a location, name, and price of objects. For example</p>
  
  <pre><code>Location | Name | Price
  Store 1    Apple   $.50
  Store 1    Pear    $.75
  Store 2    Peach   $.75
  Store 3    Mango   $1.50
  Store 3    Melon   $2.00
  </code></pre>
  
  <p>What I want returned is</p>
  
  <pre><code>Location | Name | Price
  Store 1    Apple   $.50
  Store 2    Peach   $.75
  Store 3    Mango   $1.50
  </code></pre>
  
  <p>How can I do this?</p>