ORDER BY sort_expression [DESC | ASC] [,...]The default is to perform an ascending (ASC) sort.To sort by last_name and then by first_name, you could use either of the following Select statements:In the second example, last_name is the second item in the Select list, so ORDER BY 2,3 sorts by last_name and then by first_name.See SQL Expressions for details regarding SQL expressions.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |