Need help with sum

My table looks like this:

name...................price
Schwarzenegger...........100
Fonda.....................10
Fonda.....................40
Fonda....................200
Thomas....................50
Thomas....................20

Sql should give this:

name...................price
Schwarzenegger...........100
Fonda....................250
Thomas....................70

The sum command does not seem to work in this case (only whole columns?), any help would be greatly appreciated :-). Received on Fri May 25 2001 - 08:44:04 CDT