Download java db 10621

Example using a correlation name Download java db 10.6.2.1 can sort the result set by a correlation name, if the correlation name is specified in download java db 10.6.2.1 select list. Example using a numeric expression You can sort the result set by a numeric expression, for example: Example using a function You can sort the result set by invoking a function, for example: SELECT i, len FROM measures ORDER BY sin i.

It can also be used in an Download java db 10.6.2.1 statement or a CREATE VIEW statement. An ORDER BY clause allows you to specify the order in which rows appear in the result set. It is permissible to combine ORDER BY on the outer query with ORDER BY in subqueries. You can sort the result set by a correlation name, if the correlation name is specified in the select list. The ORDER BY clause is an optional element of the following: A SELECT statement A SelectExpression A VALUES expression A ScalarSubquery A TableSubquery.

The column-Name that you specify in the ORDER BY clause does not need to download java db 10.6.2.1 the SELECT list. ColumnPosition An integer that identifies the number of the column in the Download java db 10.6.2.1 in the underlying query of the SELECT statement.

Expression A sort key expression, such as numeric, string, and datetime expressions. Expression can also be a row value expression such as a scalar subquery or case expression.

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 specified in the SELECT list.

Notes If SELECT DISTINCT is specified or if the SELECT statement contains a GROUP BY clause, the ORDER BY columns must be in the SELECT list.

An ORDER BY clause prevents a SELECT statement from being an updatable cursor. For more information, see Requirements for updatable cursors and updatable ResultSets. If the null ordering is not specified then the handling of the null values is: NULLS LAST if the sort is ASC NULLS FIRST if the sort is DESC Download java db 10.6.2.1 neither ascending nor descending order is specified, and the null ordering is also not specified, then both defaults are used and thus the order will be ascending with NULLS LAST.

ASC Specifies that the results should be returned in ascending order. If the order is not specified, ASC is the default. DESC Specifies that the results should be returned in descending order. NULLS FIRST Specifies that NULL values should be returned before non-NULL values. NULLS LAST Specifies that NULL values should be returned after non-NULL values.

Example specifying null ordering You can specify the position of NULL values using the null ordering specification: