Hi,
I have a database where I have to find the highest point
aggregator. I am new to mysql. Would you please let me know what query
would be good for getting what I want? The sample is below.

Thanks:


Name | Points
Jack 10
Mack 20
Jack 25
Jack 25
Mack 30
John 5
Jack 10
John 10
John 5
Jill 10
John 30
Jill 10

select max(points)

<premgrps [at] gmail.com> wrote in message
news:1151543569.508133.31450 [at] y41g2000cwy.googlegroups.com...
> Hi,
> I have a database where I have to find the highest point
> aggregator. I am new to mysql. Would you please let me know what query
> would be good for getting what I want? The sample is below.
>
> Thanks:
>
>
> Name | Points
> Jack 10
> Mack 20
> Jack 25
> Jack 25
> Mack 30
> John 5
> Jack 10
> John 10
> John 5
> Jill 10
> John 30
> Jill 10
>