In the select-list in SELECT statements, each expression can be followed by [AS] newname, where the AS keyword is optional, and newname is a name-title for the column. The newname can optionally be enclosed in double quotes (as can all names). For more information, see Teradata ODBC Specific Comparison Operators (deprecated in 14.10).
This syntax is compatible with X/OPEN™ SQL (X/Open requires the AS keyword), ANSI SQL 1992, Microsoft Access SQL, SyBase/SQL Server, and several others.
In addition, for better SQL Server compatibility, the newname can be enclosed in single quotes instead of double quotes, although the use of single quotes should be discouraged since it is not ANSI-compliant. Teradata recommends that you do not use Teradata TITLE or NAMED clauses, and instead use this syntax when possible.