Subject: | Sorting numeric values in aggregate functions |
I have a table that has a column
sales NUMERIC(20,3)
that can have both positive and negative values
if I try to get a sum over a date range and sort by that aggregate value
with a limit to 40 results it does not correctly sort by numeric order.