My only question is, why didn't you type this directly into SQL*Plus to
see what would happen? I'm no SQL expert but that query looks like it
should be exactly right.
locnet wrote:
> 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.
>
--
Email address munged to avoid SPAM
Reverse the last two parts to reply directly
Received on Fri Nov 01 2002 - 05:15:27 CST
