sqlserver 和Oracle中 order by的区别

Answer 1

sqlserver 认为 null 最小。升序排列：null 值默认排在最前。要想排后面，则：order by case when col is null then 1 else 0 end ,col降序排列：null 值默认排在最后。要想排在前面，则：order by case when col is null then 0 else 1 end , col desc！