In “Sorting Query results” in Chapter 3, the word “aggregates” has been dropped from this sentence:
“Adaptive Server does not allow subqueries, variables and constant expressions in the order by list.” Asuccessful example in the following section, order by and group by, uses the aggregate function avg(price) in an order by clause:
order by avg(price)
