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 same pay rate, I want to select the one that has the lowest unique ID number. Can anyone help me on how to write this query? Thanks! -Casey Sheridan [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]