premgrps@gmail.com wrote:
> Hi,
> I have a database where I have to find the summation of points for
> each person. The example below has the name repeating multiple times.
> 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 name, sum(points) from mytable group by name