我们在使用排序 order by 的时候,如果使asc排序,发现null值的数据总会排在最前面。
解决办法:使用 is null,在需要null值排在后面的字段前加上"该字段名 is null,"
例如: order by sort asc 改写成 order by sort is null, sort asc
order by name asc, sort asc 改写成 order by name asc, sort is null, sort asc
oracle https://www.cnblogs.com/anlove0328-1121/p/5481383.html
参考:https://blog.csdn.net/layman1024/article/details/79257756