Order by的几种用法
- 格式:doc
- 大小:12.00 KB
- 文档页数:1
Order by的几种用法
单列升序:select from order by ;单列降序:select from table_name order by desc;多列升序:select , from table_name order by , ;多列降序:select , from order by desc, desc;多列混合降序:select column_one, column_two from table_name order by column_one desc, column_two desc;2. 按列的位序排序, 默认是升序select * from order by 13. NULL排序空值在前:select from order by NULLS FIRST;空值在后:select from order by NULLS LAST;
1