如下:
按照表中某一字段排序。该字段可能存在空值,发现在升序排列时空值排在最前。
mysql语句如下:
mysql>
select
*
from
bjy_order
order
by
order_number
asc
;
+
----+------+--------------+
| id | city | order_number |
+
----+------+--------------+
| 1 | 北京 |
NULL
|
| 3 | 广州 |
NULL
|
| 4 | 河北 |
NULL
|
| 6 | 河南 |
NULL
|
| 2 | 上海 | 1 |
| 5 | 天津 | 2 |
+
----+------+--------------+
但需求要将空值排最后。其余按照升序或降序排列,修改为如下语句即可.
(其中 “order_number
is
null
”
可按照具体条件修改)
mysql>
select
*
from
bjy_order
order
by
order_number
is
null
,order_number
asc
;
+
----+------+--------------+
| id | city | order_number |
+
----+------+--------------+
| 2 | 上海 | 1 |
| 5 | 天津 | 2 |
| 1 | 北京 |
NULL
|
| 3 | 广州 |
NULL
|
| 4 | 河北 |
NULL
|
| 6 | 河南 |
NULL
|
+
----+------+--------------+
转自:http://blog.sina.com.cn/s/blog_b41a8dd00102wtt0.html