Originally posted by aus
Isn't what you want in the rest of that article (this page)? If it isn't, then I am unsure what you are asking.
That's correct, or at least is seem like what I'm looking for, but when I try the following query (from their example):

SELECT article, dealer, price
FROM shop s1
WHERE price=(SELECT MAX(s2.price)
FROM shop s2
WHERE s1.article = s2.article);

I get the following error:
ERROR 1064: You have an error in your SQL syntax near 'SELECT MAX(s2.price) FROM shop s2 WHERE s1.article =' at line 3

(I'm using MySQL 3.23.55)

And I have no idea what could be wrong ..