Syntax
ORDER BY { | ColumnPosition }
[ ASC | DESC ]
[ , | ColumnPosition
[ ASC | DESC ] ] *
ColumnPosition is an integer that identifies the
number of the column in the SelectItem in the underlying Query of
the . ColumnPosition must be greater than 0 and not greater than the number of columns in
the result table. In other words, if you want to order by a column, that column
must be in the select list.
refers to
the names visible from the SelectItems in the underlying
query of the . An order by column does
not need to be in the select list.
ASCimplied in ORDER BY clauseDESCoptional element of ORDER
BY clauseASC specifies that the results should be returned
in ascending order; DESC specifies that the results should be returned in
descending order. If the order is not specified, ASC is the default.
ORDER BY clauseaffecting cursorsAn ORDER BY clause prevents a SELECT statement from being an updatable
cursor. (For more information, see .)
For example, if an INTEGER column contains integers, NULL is considered
greater than 1 for purposes of sorting. In other words, NULL values are sorted
high.