sql sever默认null最小
升序排序
null值在最前面,若要放在后面,则:
order by case when col is null then 1 else 0 end, col
降序排序
null值在最后面,若要放在前面,则:
order by case when col is null t...
sql sever默认null最小
升序排序
null值在最前面,若要放在后面,则:
order by case when col is null then 1 else 0 end, col
降序排序
null值在最后面,若要放在前面,则:
order by case when col is null t...