Re: SQL question

You can use:

    SELECT Name, MAX(Score)

        FROM your_table_name
        GROUP BY Name

good luck

Komix Hui
kkmhui_at_peoplesphone.com.hk

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 Thu Dec 03 1998 - 11:37:19 CET