Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SELECT statementUse the SELECT statement to retrieve values from a database or from an SPL or collection variable. A SELECT operation is called a query.
ORDER BY ClauseThe ORDER BY clause sorts query results by specified columns or expressions.
Ordering by Rowids

Ordering by Rowids

You can specify the ROWID keyword in the ORDER BY clause. This specifies the rowid column, a hidden column in nonfragmented tables and in fragmented tables that were created with the WITH ROWIDS clause. The rowid column contains a unique internal record number that is associated with a row in a table. (It is recommended, however, that you utilize primary keys as your access method, rather than exploiting the rowid column.)

The ORDER BY clause cannot specify the rowid column if the table from which you are selecting is a fragmented table that has no rowid column.

You do not need to include the ROWID keyword in the Projection clause when you specify ROWID in the ORDER BY clause.

For further information about rowid values and how to use the rowid column in column expressions, see WITH ROWIDS Option and Using Rowids.