Various Miscellaneous Functions are avaialble in Teradata. For example: COALESCE, TYPE, XMLAGG, MAX, MIN, SUM etc.

Teradata Miscellaneous Functions

Teradata provides many functions which can be used to fulfil various user requirements, click on the required function to get detail

Other functions
Aggregate functions

Aggregate functions are used to evaluate data based on grouping of other columns.
  1. These functions cannot be used in WHERE clause of SELECT statement but can be used in WHERE clause of ABORT statement.
  2. HAVING clause can be used to filter rows based on these functions