i have DB with 2 columns: first colums is ID that can repeat itself and the second column id amount
for exaple
a435f3 12 sadfsaf 10 a435f3 17 wer34 9
i want a print that a435f3 total of 29 sadfsaf total of 10 wer34 total of 9
thanks in advance peleg
SELECT id, sum(amount) FROM table GROUP BY id