* Aleksandar Bradaric > >> 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.
Yes. > If you use older MySQL version then it's not possible to do > it with a single query :( Yes, it is. :) <URL: http://www.mysql.com/doc/en/example-Maximum-column-group-row.html > See the "MAX-CONCAT trick". -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]