GROUP BY Clause Examples | SQL SELECT Statements | Teradata Vantage - Example: Simple GROUP BY Operation - Analytics Database - Teradata Vantage

Generate a report of salary totals by department, the result might look something like the report that follows.

     SELECT dept_no, SUM(salary)
     FROM employee
     GROUP BY dept_no;

The result might be similar to the report that follows.