Eliminate duplicates

[stephenson22]

I would like to remove duplicates in a query by distincting only one column.

So far I only use the max function on the related rows aside from the one
with the duplicates.

Is their a method to use a "top row" of some kind for each distinct value??

Please help