|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
select max(points)
<premgrps@gmail.com> wrote in message news:1151543569.508133.31450@y41g2000cwy.googlegro ups.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 > |
|
![]() |
| Outils de la discussion | |
|
|