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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Querying and modifying data » 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

Explicitly limiting the number of rows returned by a query
ORDER BY and GROUP BY