--单独将空值排序在最后
select * from users us order by us.create_time nulls last;
--单独将空值排序在最前
select * from users us order by us.create_time nulls first;
--时间倒叙
select * from users us order by us.create_time nulls last, us.create_time desc;
--倒叙和空值排序合在一起你以为是这样的?天真呐少年
select * from users us order by us.create_time nulls last, us.create_time desc;
--实际上是这样子滴
select * from users us order by us.create_time desc nulls last;
空值排序与时间倒叙问题
最新推荐文章于 2023-07-19 17:06:27 发布