1. 问题背景
用ORDER BY排序的时候,NULL值在前面,但是有时候我们最想看到的值不是NULL,那么我们就要把NULL值放到后面。
2. 解决方案
https://learnsql.com/blog/how-to-order-rows-with-nulls/#:~:text=If%20you%20sort%20a%20column,the%20NULLs%20will%20come%20first.&text=Alternatively%2C%20if%20you%20add%20a,order%2C%20NULLs%20will%20appear%20last.