ORDER BY Clause | SQL SELECT Statements | VantageCloud Lake - ORDER BY Clause - Teradata VantageCloud Lake

An expression in the SELECT list that specifies how result sets are sorted. If you do not use this clause, result rows are returned unsorted.

• ORDER BY Clause Syntax
• ORDER BY Clause Usage Notes
• ORDER BY Clause Examples
• ORDER BY Clause Related Information

ANSI Compliance

The ORDER BY clause is ANSI SQL:2011-compliant with extensions. The specification of an ORDER BY clause in the definition of an updatable cursor is ANSI SQL:2011-compliant.

The specification of an expression as an ordering argument in the ORDER BY clause is a Teradata extension to the ANSI SQL:2011 standard.