C
chhuan123
Unregistered / Unconfirmed
GUEST, unregistred user!
一个表有一字段Tracer,里面有Sum、SJ、Old Stock、ching几个内容,
使用:select Tracer from table order by Tracer
得到的是:
+------------+
| SKU_Tracer |
+------------+
| ching |
| Old Stock |
| SJ |
| Sum |
+------------+
使用:select Tracer from table order by Tracer desc
得到的是:
+------------+
| SKU_Tracer |
+------------+
| Sum |
| SJ |
| Old Stock |
| ching |
+------------+
怎么样才可以得到:
+------------+
| SKU_Tracer |
+------------+
| SJ |
| Sum |
| ching |
| Old Stock |
+------------+
呢?即可以按照我的要求排序。。。
请高手赐教噢!!
使用:select Tracer from table order by Tracer
得到的是:
+------------+
| SKU_Tracer |
+------------+
| ching |
| Old Stock |
| SJ |
| Sum |
+------------+
使用:select Tracer from table order by Tracer desc
得到的是:
+------------+
| SKU_Tracer |
+------------+
| Sum |
| SJ |
| Old Stock |
| ching |
+------------+
怎么样才可以得到:
+------------+
| SKU_Tracer |
+------------+
| SJ |
| Sum |
| ching |
| Old Stock |
+------------+
呢?即可以按照我的要求排序。。。
请高手赐教噢!!