[SQL] グループ化

GROUP BY を使用

Select Key, MAX(key1), SUM(key2)・・・
From TEST_TABLE
Group By key
Where ・・・

Select Count(*)
From TEST_TABLE
Group By Key

複数キーの指定も可
Select ・・・
From ・・・
Group By Key1, Key2