15.10 - ORDER BY - 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

Index rows are ordered on each AMP by a single value- or hash-ordered column.

  • If you specify ORDER BY, then you must also specify column_name_2.
  • If you do not specify ORDER BY, Teradata Database orders rows by the hash value of all the columns in the column_name list.
VALUES
Value-ordering for the ORDER BY column.
If neither VALUES nor HASH is specified, VALUES is used as the default.
HASH
Hash-ordering for the ORDER BY column.
column_name_2
A single column from the column list defined by column_name that specifies the sort order to be used for either HASH or VALUES.
The size of the column is limited to four or fewer bytes. Supported numeric date types for column_name_2 are the following.
  • BYTEINT
  • DATE
  • DECIMAL
  • INTEGER
  • SMALLINT
If you specify ORDER BY without also specifying an explicit 
column_name_2, then the system assumes the first column specified in the column_name list.