Oracle sql排序中null值参与排序的写法

null放在排序最前：

select * from table order by A desc nulls first;

null放在排序最后：

select * from table order by A desc nulls last;