select * from student order by to_number(studentid) 转载于:https://www.cnblogs.com/choiyubo163com/p/6422042.html