I'm trying to order a sqlquery by an aggregate and having no luck.
Select Account, SUM(Cost)
group by account
order by SUM(Cost)
the query runs fine. But it is not ordered as asked. The thing that throws me off is that it returns a result, no error. I can change the order to DESC and it runs but the order does not change at all.