Re: SQL question
From: (wrong string) é Nicolau <jnicolau_at_hotmail.com>
Date: Sun, 16 Aug 1998 13:00:53 +0200
Message-ID: <35D6BBE4.1D849301_at_hotmail.com>
Date: Sun, 16 Aug 1998 13:00:53 +0200
Message-ID: <35D6BBE4.1D849301_at_hotmail.com>
Am I dreaming or the solution is like this? select name, max(score) from table group by name; sirirut vanichayobon wrote:
> Hi,
>
> I would like to use SQL (I don't want to use PL/SQL) with one
> 'select' command to retrieve Name and the highest scoret in that name as
> the following.
>
> Table:
> Name Score
> ================
> Bill 10
> Bill 60
> Bill 30
> Tom 40
> Tom 10
>
> Result:
> Name Score
> ===============
> Bill 60
> Tom 40
>
> Any help would appreciate.
>
> Thanks,
> -sirirut-
Received on Sun Aug 16 1998 - 13:00:53 CEST