1. 表结构如下:
表名为:t_user
列为:name,age,createTime
说明:createTime可能存在null值
2. 按createTime列排序,如果值为null放在结果集的开始
select name, age, createTime from t_user order by createTime nulls frist;
3. 按createTime列排序,如果值为null放在结果集的末尾
select name, age, createTime from t_user order by createTime nulls last;
表名为:t_user
列为:name,age,createTime
说明:createTime可能存在null值
2. 按createTime列排序,如果值为null放在结果集的开始
select name, age, createTime from t_user order by createTime nulls frist;
3. 按createTime列排序,如果值为null放在结果集的末尾
select name, age, createTime from t_user order by createTime nulls last;