GROUP BY clause
Topic group Related topics
The GROUP BY clause specifies how retrieved rows are grouped for aggregate functions. For example,
SELECT PART_NO, SUM(QUANTITY) AS PQTY ;
FROM PARTS ;
GROUP BY PART_NO
Aggregates in the SELECT clause must have a GROUP BY clause if a projected field is used, as shown in the example above.