Can't have aggregate function in ORDER BY clause (Item).

Error 3097

You can't use an aggregate function in the ORDER BY Clause (SQL)15DW835 of an SQL statement29F05E5.

See Also

SQL Aggregate FunctionsM7QTSY