'Order By' clauses can be used in select(). It will sort the results that are found by select() by the specified $column, either ASCENDING or DESCENDING. An 'Order By' clause is an array in the following format

     array($column, [ASC|DESC])

where $column is the column to sort the results by. If the $column is not in the result set, then txtSQL will issue an error.