Re: a SQL quiz

You can try this query :

SELECT a.item,a.month,a.price
  FROM my_table a
WHERE a.month = (SELECT MAX(b.month)

                    FROM my_table b
                   WHERE a.item = b.item);

abray_at_club-internet.fr Received on Sun May 16 1999 - 20:11:42 CDT