Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification » Summarizing, grouping, and sorting query results

 

The ORDER BY clause: Sorting query results

The ORDER BY clause allows sorting of query results by one or more columns. Each sort can be ascending (ASC) or descending (DESC). If neither is specified, ASC is assumed.

 A simple example
 Sorting by more than one column
 Using the column position
 ORDER BY and NULL
 ORDER BY and case sensitivity

Row limitation clauses in SELECT, UPDATE, and DELETE query blocks
ORDER BY and GROUP BY