Sorts data returned by a query. Use this clause to order the result set of a query by the specified column list. The order in which rows are returned in a result set are not guaranteed unless an ORDER BY clause is specified.
ORDER BY order_by_expression [ ASC | DESC ] [ ,...n ]
Specifies a column on which to sort the query result set. A sort column can be specified as a name or column alias.
- Multiple sort columns can be specified.
- Column names must be unique.
- For now, the columns specified must be included in the select list.
- The sequence of the sort columns in the ORDER BY clause defines the organization of the sorted result set. That is, the result set is sorted by the first column and then that ordered list is sorted by the second column, and so on.
Specifies that the values in the specified column should be sorted in ascending or descending order.
ASC sorts from the lowest value to highest value.
DESC sorts from highest value to lowest value.
ASC is the default sort order. Null values are treated as the lowest possible values.
A. Specifying a single column defined in the select list
The following example orders the result set by the numeric
price column. Because a specific sort order is not specified, the default (ascending order) is used.
SELECT * FROM financial.pricing ORDER BY price
B. Specifying an alias as the sort column
The following example specifies the column alias
current_price as the sort order column.
SELECT symbol, price AS current_price FROM financial.pricing ORDER BY current_price
C. Specifying a descending order
The following example orders the result set by the numeric column
price in descending order.
SELECT symbol, price AS current_price FROM financial.pricing ORDER BY price DESC
D. Specifying an ascending order
The following example orders the result set by the
symbol column in ascending order. The characters are sorted alphabetically, not numerically.
SELECT symbol, price FROM financial.pricing ORDER BY symbol ASC