Oralce 空值排在前,或排在后边:

1
2
3
4
5
-- oracle 空值排序,排在最前面或者最后面
-- 1:
order by name nulls first;
-- 2:
order by name nulls last;