[gameprogrammer] SQL Question

[Kevin Jenkins <gameprogrammer@rakkar.org>]

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