Get subtotal in a Query

[JPIN2008]

Hello

From a table with :


P_Code P_Name Q_receved
ID_1 A 3
ID_2 B 5
ID_1 A 2
ID_3 C 1
ID_2 B 3
ID_3 C 3

How can i get the name and subtotal like this :

P_Name Q_receved
A 5
B 8
C 4

Thank you for your attention

 

[Douglas J. Steele]

SELECT P_Name, SUM(Q_receved)
FROM MyTable
GROUP BY P_Name