Query db

[hamon]

How i select the sum of each row by quantity and group by cod?

id cod quantity
1 pinco 4
2 panco 3
3 panco 9

i want from that query:

pinco sum is 4
panco sum is 13

[Zvoni]

How i select the sum of each row by quantity and group by cod?

id cod quantity
1 pinco 4
2 panco 3
3 panco 9

i want from that query:

pinco sum is 4
panco sum is 13

Uhhh.... start learning SQL?

SELECT 
cod,
SUM(quantity) As qty 
FROM 
MyTable 
GROUP BY 
cod

EDIT: Just saw it: Yeah, 9 + 3 is 13 .......
Add basic math to learning SQL.....

[hamon]

Yep, i start. thank you.