Teradata GROUP BY Clause

Teradata Group By clause makes the group of related rows. The group by clause identifies the rows which have the same value for the specified attribute (i.e, duplicate value) and returns a single row of information instead of all the rows where the attribute has the same value.

This can be done by specifying one or more columns in a table as grouping column(s).

Teradata GROUP BY syntax

The syntax of the Teradata GROUP BY clause is as below. 

Select column_name 
from DatabaseName.TableName
Group By column_name;

With Aggregate Function

Select column_name , sum(column_2)
from DatabaseName.TableName
Group By column_name;

Please note that column_name can be used with the aggregate function only if it appears in the GROUP BY clause.

Teradata GROUP BY clause example

Consider the following employee table.

The below query finds the numbers of employees in the different departments.

Select department, count(emp_id) 
from Teradatapoint.employee
group by department;

Output: