Welcome Guest, Not a member yet? Register   Sign In
Suggestion: Order by is null condition
#3

Hi,
If you are using MySQL NULL values are considered having a lower value than any none NULL value, so order by "fieldName" ASC will give you NULL values first.
And The opposite order by "fieldName" DESC will put the NULL values last.
Regards
A good decision is based on knowledge and not on numbers. - Plato

Reply


Messages In This Thread
Suggestion: Order by is null condition - by jojo - 08-15-2022, 03:24 AM
RE: Suggestion: Order by is null condition - by salain - 08-17-2022, 06:19 AM



Theme © iAndrew 2016 - Forum software by © MyBB