a Max fonction in sql ?

My table is

article | price

car     |  1000
car     |   800
car     |   900
bicycle |    50
bicycle |    60
bicycle |    20
train   |  7000

and I want the bigger price for each article :

article | price

car     |  1000
bicycle |    60
train   |  7000

I'd like something like a hypothetic MAX function that work on group : SELECT article, MAX(price)
FROM table
GROUP BY article

Does something similar existe ?

Thanks. Received on Sat Nov 02 2002 - 04:01:03 CST