<p>Hi,</p>
<p> </p>
<p>I have a table in following format,</p>
<p>product name/product value</p>
<p>honda/10000</p>
<p>toyota/30000</p>
<p>honda/25000</p>
<p>GMC/40000</p>
<p>GMC/15000</p>
<p>toyota/18000</p>
<p>What I need to do is get a name of the product and corresponding max value for that product and get rid of duplicates.</p>
<p>So the output for above example would be,</p>
<p>honda/25000</p>
<p>toyota/30000</p>
<p>GMC/40000</p>
<p> </p>
<p>Since this is coming from flat files, I do not have an option to a select * from distinct. What other methods can I use to get the intented output?</p>
<p> </p>
<p>Thanks in advance.</p>
