Provisional standings.... howto.

[Anon]

Hi:

This can be a very simple query, but I'm stuck with those. I need to count the number of points that someone has during different races. Lets say:

RaceNo Name Points
1 RacerA 1
1 RacerB 3
1 RacerC 2
2 RacerA 2
2 RacerB 1
2 RacerC 3

How to in a select statement to sum the points of each racer to create a provisional standings?

[Anon]

I think you can do this:

SELECT SUM(Points) FROM tbl_name GROUP BY Name

Diego

[[deleted]]

You can use SUM() to add values, and you can use GROUP BY to get results for groups of records:

SELECT name, sum(points) AS totalpoints
FROM table
GROUP BY name;

this will get records in groups that have the same 'name' and it will add then points for each of those groups and return them.