针对字符型数字按int排序

2019独角兽企业重金招聘Python工程师标准>>>

1. 针对字符型数字按int降序排序

Mysql三种办法：

1. 在排序字段前加上-号，转为int型负数，排序

   	SELECT * FROM  Student WHERE 1 = 1 ORDER BY -age asc;
   

2. 对排序字段做数学运算，如 +1，

   	SELECT * FROM  Student WHERE 1 = 1 ORDER BY (age + 1) desc ;
   

3. 先对位数排序，在对数字排序

   	select * from Student order by length(age) desc,age desc;
   

---

转载于:https://my.oschina.net/u/3686885/blog/1935006