Hi, > I have already tried the 'rtfm', but it just didn't help.
But it's right there :) 3.5.2 The Row Holding the Maximum of a Certain Column > ..and I want to get this with a single query: > +-----+--------+------+ > | key | desc | value | > +-----+--------+------+ > | 2 | book | 7 | > | 6 | pen | 7 | > +-----+--------+------+ select key, desc, value from your_table t1 where value = (select max(value) from your_table where desc = t1.desc) Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]