Re: a Max fonction in sql ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 1 Nov 2002 22:22:10 +1000
Message-ID: <0htw9.67160$g9.188746@newsfeeds.bigpond.com>

Hi locnet,

Why not try out your SQL.

You'll be pleasantly surprised ;)

Richard
"locnet " <"locnet "@free.fr> wrote in message news:3DC3A25F.9030304_at_free.fr...
> 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 Fri Nov 01 2002 - 06:22:10 CST