---总结:在排序的过程中 列中值为null的当成0处理了
1.
---查询
select * from Student;
2.
---升序查询
select * from Student
order by SortNumber;
3.
---倒叙查询 (作为常用处理方式比较好)
select * from Student
order by SortNumber desc;
---总结:在排序的过程中 列中值为null的当成0处理了
1.
---查询
select * from Student;
2.
---升序查询
select * from Student
order by SortNumber;
3.
---倒叙查询 (作为常用处理方式比较好)
select * from Student
order by SortNumber desc;
转载于:https://my.oschina.net/tianma3798/blog/591484