1.默认排序,会将null值排在首位
select * from student
order by age
2.null值后排
select * from student
order by ISNULL(age)
3.null值后排,非null升序
select * from student
order by ISNULL(age), age
1.默认排序,会将null值排在首位
select * from student
order by age
2.null值后排
select * from student
order by ISNULL(age)
3.null值后排,非null升序
select * from student
order by ISNULL(age), age