select a from table_name where a>9000 order by a union select a from table_name where a<9000 order by a
select * from T order by length(a) desc,a
select * from T order by substr(a,1,1) desc,substr(a,length(a)-1,1) 不知行不?
楼主是想实现一个循环的链式排序吧?我没有试过,不过你可以试试,如果你要对10000个数进行这样的排序,试试如下与句:select c_name, case when c_name >= 10000 / 2 then c_name - 10000 when c_name < 10000 / 2 then c_name + 10000 end c_order from t_name order by c_order;这样对上面的例子可以
union
select a from table_name where a<9000 order by a
order by length(a) desc,a
order by substr(a,1,1) desc,substr(a,length(a)-1,1)
不知行不?
case when c_name >= 10000 / 2 then c_name - 10000
when c_name < 10000 / 2 then c_name + 10000
end c_order
from t_name order by c_order;这样对上面的例子可以