Ascending order

You can retrieve results in ascending order by specifying ASC in the ORDER BY clause of your SELECT statement.

Begin general-use programming interface information.

For example, the following query retrieves the employee numbers, last names, and hire dates of employees in department A00 in ascending order of hire dates:

SELECT EMPNO, LASTNAME, HIREDATE
  FROM EMP
  WHERE DEPT = 'A00'
  ORDER BY HIREDATE ASC;

The result table looks like this:

EMPNO      LASTNAME      HIREDATE
======     =========     ==========
000010     HAAS          1975-01-01
200010     HEMMINGER     1985-01-01
000120     CONNOR        1990-12-05

This SELECT statement shows the seniority of employees. ASC is the default sorting order.

End general-use programming interface information.