if I have the following cursor and I want a total of each amount belonging to an item how would I go about writing an sql statement for that.

x        y
2        bells
5        tables
3        bells
4        glasses

I need the result to show up as:

x        y
5        bells
4        glasses
5        tables

Thanks
Nick Patel