oracle查询varchar排序

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

查询语句如： select s.id from student s order by s.id desc; 结果如下：

查询语句修改为：select s.id from student s order by cast(s.id as int) desc;

 

 

转载于:https://my.oschina.net/u/3529861/blog/1031030