Built-in functions or keywords that are explicitly prohibited, such as DEFAULT or PARTITION For information about the DEFAULT built-in function, see Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145. For information about the PARTITION keyword, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146. These expressions must be aliased. Otherwise, the system returns an error to the requestor.
For two columns with the same name, you must alias both names using a column name alias. See Teradata Vantage™ - SQL Fundamentals, B035-1141.
If you also define a repeating group column_name list, the system stores each distinct value of the column_name list only once.