[gameprogrammer] SQL Question

I want to order a table by a column, and return the first row that has a unique value for a different pair of columns. 

For example:

Column_1, Column_2, Column_3
John,     Doe,      $85
John,     Archer,   $90
Bob,      Barker,   $70
John,     Doe,      $60

It should return
John,     Doe,      $85
John,     Archer,   $90
Bob,      Barker,   $70
Because John, Doe appears twice, it only returns the row with the higher value for Column 3 

How would I do this?

Thanks!

---------------------
To unsubscribe go to http://gameprogrammer.com/mailinglist.html

Other related posts: