15.10 - AS expression_alias - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

A mandatory unique alias for a SUM, COUNT, MIN, MAX, or extracted year or month expression.

The keyword AS preceding expression_alias is optional.

All expressions specified in the select list must be aliased. Otherwise, Teradata Database returns an error to the requestor.

This name permits further use of the result as the grouping key for a GROUP BY clause or the ordering key for an ORDER BY clause.