The following query returns results ordered by name:

SELECT ID, Name
   FROM Products
   ORDER BY Name;

If you name more than one column in the ORDER BY clause, the sorts are nested.

The following statement sorts the shirts in the Products table first by name in ascending order, then by quantity (descending) within each name:

SELECT ID, Name, Quantity
   FROM Products
   WHERE Name like '%shirt%'
   ORDER BY Name, Quantity DESC;

You can use the position number of a column in a SELECT list instead of the column name. Column names and SELECT list numbers can be mixed. Both of the following statements produce the same results as the preceding one.

SELECT ID, Name, Quantity
   FROM Products
   WHERE Name like '%shirt%'
   ORDER BY 2, 3 DESC;
SELECT ID, Name, Quantity
   FROM Products
   WHERE Name like '%shirt%'
   ORDER BY 2, Quantity DESC

Most versions of SQL require that ORDER BY items appear in the SELECT list, but SQL Anywhere has no such restriction. The following query orders the results by Quantity, although that column does not appear in the SELECT list:

SELECT ID, Name
   FROM Products
   WHERE Name like '%shirt%'
   ORDER BY 2, Quantity DESC;

With ORDER BY, NULL sorts before all other values in ascending sort order.

The effects of an ORDER BY clause on mixed-case data depend on the database collation and case sensitivity specified when the database is created.