So Null is one of the if not the highest value in a list of values.
Whenever i order by some column, null has always been the highest.
However when I use the least function
select * from invoices order by terms_of_discount desc;
select LEAST('2', '5', '12', '3', null) from dual;
select LEAST('apples', 'applis', 'applas', null) from dual;
In both cases null is the lowest
so i'm wondering why this is.
As oradocs mention:
DESCRIPTION
The Oracle/PLSQL LEAST function returns the smallest value in a list of expressions.