You can also sort by using the position of the column..
order by 1,2
Not the best of things to do as it is all to easy to forget to change the
sort parameter if the select list changes but very good if you are building
SQL in code with variable lists.
> How do you use ORDER BY with an aggregate query? I have a query that is
> something like:
> SELECT this, sum(that) AS theother
> FROM atable
> GROUP BY this
> what I want to do is append ORDER BY to rank the summed values.
> Anyone know how to do that?