SUM関数でレコードの値を集計、GROUP BY句で結果をグループ分けする方法
mysql> SELECT shcd,SUM(suryo) FROM t_hanbai GROUP BY shcd; +--------+------------+ | shcd | SUM(suryo) | +--------+------------+ | 100001 | 10 | | 100101 | 3 | | 100201 | 5 | | 100A01 | 7 | | 100B01 | 2 | +--------+------------+ 5 rows in set (0.16 sec)