1、将空值放在最前面
select * from table order by column asc/desc nulls first
2、将空值放在最后面
select * from table order by column asc/desc nulls last
1、将空值放在最前面
select * from table order by column asc/desc nulls first
2、将空值放在最后面
select * from table order by column asc/desc nulls last