Home | 简体中文 | 繁体中文 | 杂文 | Github | 知乎专栏 | Facebook | Linkedin | Youtube | 打赏(Donations) | About
知乎专栏

24.3. order by 排序

24.3.1. 处理 null

null 排在后面

			
select * from user order by age asc;

select * from user order by age is null desc, age desc;
			
			

null 排在后面

			
select * from user order by age is null asc,age asc;

select * from user order by age desc;