Hi, >> select key, desc, value >> from your_table t1 >> where value = (select max(value) from your_table where desc = t1.desc)
> Anyway, when i execute this query, i get an error near 'select > max(value)'... :( It's because the subselects are supported from version 4.1. If you use older MySQL version then it's not possible to do it with a single query :( Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]