"Casey Sheridan" <[EMAIL PROTECTED]> wrote:
> I have a table that has employee names, pay rates, and unique IDs. I want
> to select all of the distinct employee names, and if there are two employees
> with the same name, I want to be able to choose only one; the one with the
> highest pay rate. I
I have a table that has employee names, pay rates, and unique IDs. I want
to select all of the distinct employee names, and if there are two employees
with the same name, I want to be able to choose only one; the one with the
highest pay rate. If there are two identical employee names with the sa
