1.空值排序
1,排在最前面用order by name nulls first;
2,排在最后面order by name nulls last;
2.多个条件排序
1.select * from 表 order by a ,b desc;
先按照a升序排 再对结果按照b降序排
1,排在最前面用order by name nulls first;
2,排在最后面order by name nulls last;
1.select * from 表 order by a ,b desc;
先按照a升序排 再对结果按照b降序排