Hello,

I'm trying to build a query with order by that puts nulls last always.

I tryed to use the "NULLS LAST" expression but apparently it's not supported by monetdb.

So i came up with something like this:

select name, sum(number)

from test

group by name

order by case when sum(number) is null then 1 else 0 end, sum(number) ASC

Thing is, this works when the ordering column (number) is not aggretated, as soon as i throw the sum in there it returns no results.

The sum of null values seems to be returning 0, is it possible to change that behaviour trough configuration? Is there a better way to achieve this?

thanks