Re: max function

[Rick James]

SELECT *
    FROM
    (   SELECT product,
               price
            FROM Products
        ORDER BY price DESC
    ) AS x
    GROUP BY product;

This should get the top price for each product.

It uses the "feature" that GROUP BY picks the first row of each group. In this case, that is the highest priced item (because of ORDER BY price DESC). If two have the same price, it will pick one at 'random'.